Autovacuum "queue" and progress
Monitor and manage autovacuum queue, understand worker activity and vacuum progress
35 docs tagged with "intermediate"
View All TagsEXPLAIN ANALYZE or EXPLAIN (ANALYZE, BUFFERS)?
UPDATE 2025: Starting with Postgres 18, the `BUFFERS` option becomes default in `EXPLAIN ANALYZE`, which is great news.
How many tuples can be inserted in a page
How to add a CHECK constraint without downtime
How to add a foreign key
How to change ownership of all objects in a database
How to convert a physical replica to logical
How to deal with bloat
Detect, measure, and eliminate table and index bloat to maintain database health
How to decide when a query is too slow and needs optimization
"Slow" is a relative concept. In some cases, we might be happy with query latency 1 minute (or no?), while in other
How to determine the replication lag
How to estimate the YoY growth of a very large table using row creation timestamps and the planner statistics
How to find int4 PKs with out-of-range risks in a large database
How to find the best order of columns to save on storage ("Column Tetris")
How to flush caches (OS page cache and Postgres buffer pool)
How to get into trouble using some Postgres features
How to import CSV to Postgres
## Source CSV we'll be using as an example
How to install Postgres 16 with plpython3u: Recipes for macOS, Ubuntu, Debian, CentOS, Docker
How to make the non-production Postgres planner behave like in production
How to monitor xmin horizon to prevent XID/MultiXID wraparound and high bloat
How to quickly check data type and storage size of a value
How to rebuild many indexes using many backends avoiding deadlocks
How to redefine a PK without downtime
How to remove a foreign key
How to run ANALYZE (to collect statistics)
Learn how to how to run analyze (to collect statistics)
How to set application_name without extra queries
How to speed up bulk load
How to troubleshoot a growing pg_wal directory
How to troubleshoot streaming replication lag
Learn how to how to troubleshoot streaming replication lag
How to tune work_mem
How to understand what's blocking DDL
How to use OpenAI APIs right from Postgres to implement semantic search and GPT chat
How to use pg_restore
Today – a few tips on using `pgrestore` to restore databases (or only parts of them) from dumps.