track stat - Search results , p.2

WAL in PostgreSQL: 4. Setup and Tuning

track changes to the system catalog. We will not go into details of backup and replication now since this is a topic for a separate series of articles. Reliability of writing It's clear that

Blog >> PostgreSQL

MVCC in PostgreSQL — 7. Autovacuum

track of the number of dead tuples, which is stored in the pg_stat_all_tables

Blog >> PostgreSQL

MVCC in PostgreSQL — 6. Vacuum

tracked by the visibility map, and the map itself gets updated. The free space map also gets updated in the process to reflect the extra free space in the pages. As usual, let's create

Blog >> PostgreSQL

What is Baked in the Baker's Dozen?

stat_statements.track_planning parameter is turned on, additional, planner, statistics will be written: the number

Blog >> PostgreSQL

Indexes in PostgreSQL — 3 (Hash)

tracked in bitmap pages, which are also allocated as the need arises. Note that hash index cannot decrease in size. If we delete some of indexed rows, pages once allocated would not be returned

Blog >> PostgreSQL

Indexes in PostgreSQL — 1

stats where tablename = 't'; attname | correlation ---------+------------- b | 0.533512 c | 0.942365 a | -0.00768816 (3 rows) Absolute values close to one indicate a high correlation (as for column "c"), while values close to zero, on the contrary

Blog >> PostgreSQL

PostgreSQL 9.6 is Released: Contribution of Postgres Professional

stat_activity. Also, the type of lock being waited for is now visible. These changes replace the waiting column with wait_event_type and wait_event. See blog post for details. Fix the default text

←

1 2