May 2018Intermediate to advanced content levelIntermediate to advanced576 pages30h 25mEnglishPackt Publishing
The Collecting daily usage statistics section shows one way to collect info on table changes Chapter 9, Regular Maintenance Chapter 10, Performance and Concurrency The How many rows in a table? recipe in Chapter 2, Exploring the Database, for an introduction to MVCC The auto_explain contrib module at http://www.postgresql.org/docs/current/static/auto-explain.html