VACUUM VACUUM — garbage-collect and optionally analyze a database Synopsis VACUUM [ ( option [, ...] ) ] [ table_and_columns …| PostgreSQL Documentation
CLUSTER CLUSTER — cluster a table according to an index Synopsis CLUSTER [ ( option [, ...] ) ] [ …| PostgreSQL Documentation
Postgres 18 introduces Asynchronous I/O (AIO) that can dramatically improve read performance, especially in the cloud. Learn how these changes and the new io_method setting work and see why our benchmark results show that io_uring is the recommended setting for maximizing I/O performance in Postgres 18 over the default setting 'worker'.| pganalyze
We continue to follow the news about PostgreSQL 18. The January CommitFest brings in some notable improvements to monitoring, as well as other new features. You can find previous reviews of PostgreSQL 18 CommitFests here: 2024-07 , 2024-09 , 2024-11 . EXPLAIN (analyze): buffers on by default pg_stat_io: input/output statistics in bytes instead of pages pg_stat_io: WAL statistics pg_stat_get_backend_io: I/O statistics for a specific process VACUUM(verbose): visibility map information Total vac...| postgrespro.com
Appendix M. Glossary This is a list of terms and their meaning in the context of PostgreSQL and relational database systems in …| PostgreSQL Documentation
19.4. Resource Consumption # 19.4.1. Memory 19.4.2. Disk 19.4.3. Kernel Resource Usage 19.4.4. Background Writer 19.4.5. I/O 19.4.6. Worker Processes 19.4.1. Memory …| PostgreSQL Documentation
19.5. Write Ahead Log # 19.5.1. Settings 19.5.2. Checkpoints 19.5.3. Archiving 19.5.4. Recovery 19.5.5. Archive Recovery 19.5.6. Recovery Target 19.5.7. WAL …| PostgreSQL Documentation
27.4. Progress Reporting # 27.4.1. ANALYZE Progress Reporting 27.4.2. CLUSTER Progress Reporting 27.4.3. COPY Progress Reporting 27.4.4. CREATE INDEX Progress Reporting …| PostgreSQL Documentation