| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 31 Jul 2025 15:05:11 GMT
content-type: text/html; charset=utf-8
cf-ray: 967dfe11be8dc151-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=c7122230-0bad-49fb-96d0-de3b74275af9; expires=Fri, 31 Jul 2026 15:05:10 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: 23461b91-b113-468e-84d6-5ba7d81d05e6
x-worker-origin-response-time: 395000000
x-dns-prefetch-control: off
set-cookie: prov=c7122230-0bad-49fb-96d0-de3b74275af9; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=UXn2BIldDZYh3wDpwmZG.yT98p.GXMnBEXOduZexhQI-1753974311-1.0.1.1-It34r2dIG4Oepvpe9RSREQmuLKyEhYLSgaRE53s8mLaFjUZmHsTsL0kJ8qtzlN7TuhXdZ1CZRhx6zXce_fw0nE7Pjj9uZjMtPwbmpMZAmXM; path=/; expires=Thu, 31-Jul-25 15:35:11 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=GKmUH1K.xq3exDuHwzy4_YGQXD8u9gHQGI6DH7iQJbY-1753974311087-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'autovacuum' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
The 2025 Developer Survey results are in. Explore insights into technology and tools, careers, community and more.
View results.
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [autovacuum]
Questions regarding the postgres autovacuum daemon.
95 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
4
votes
1
answer
196
views
Postgresql XID wrap around prevention overloading autovacuum
We have a pretty big postgres 14 database with timescaledb installed. Recently we had some issues with MXID and XID wraparound so we started to monitor these as well as autovacuum. What we noticed is ...
1
vote
1
answer
98
views
How to know, when it is time to vacuum an sqlite database file?
Sqlite, contrary most SQL-compatible DB engine, is working directly on files instead over network sockets. It is also not very good in concurrency, beside that deletion operators are mostly advisory (...
0
votes
0
answers
16
views
Auto-vacuum shows different behaviour in two similar situations. I am unable to understand why?
I have a insert-only table event on PostgreSQL-12 where I am having a high volume of inserts per sec (~2000 per sec). I regularly faced an issue when anti-wraparound auto-vacuum was running on this ...
1
vote
1
answer
78
views
Postgresql last_autovacuum and last_autoanalyze
I have a few tables that ere 1 TB+. The columns last_autovacuum and last_autoanalyze in pg_stat_user_tables have NULLs for these tables. The n_dead_tup to n_live_tup ratio is 0.0001. A few questions, ...
2
votes
2
answers
143
views
Does regular truncate & insert hurt performance?
We have a large (5 TB) PostgreSQL 15 RDS that acts as a data warehouse, data comes in through regular pipelines and then ~20 users run analytic queries on it.
Our infrastructure people have access to ...
2
votes
2
answers
458
views
PostgreSQL: Long running auto vacuum and high wal rate
Recently a vacuum process triggered by auto vacuum daemon(PostgreSQL13) on one of our table took long 1.5hr to complete. During this period there was high WAL rate up to 7MB/sec and high Disk I/O. ...
0
votes
1
answer
46
views
How to Retrieve and Compare All Settings and Overrides for a Specific Table in PostgreSQL (version 12)?
I am working with a PostgreSQL 12 database and currently investigating a table (table_name in schema schema_name) that has accumulated a significant number of dead tuples. To address this, I am ...
0
votes
1
answer
438
views
Optimizing XID management in PostgreSQL: How to avoid INSERT locks in tables?
I would like to raise a question regarding the optimal practices for managing transaction age (XID) in a PostgreSQL database.
I am currently using the method of performing VACUUM FULL operations on ...
0
votes
1
answer
77
views
Postgres: how to insert and delete many records and to not run out of space
I have a PostgreSQL installation deployed in Kubernetes (with the CloudNative operator) and allocated a 25GB volume for it. My architecture involves several microservices interacting with various ...
-1
votes
2
answers
35
views
Auto vacuum for table ASAP
In my app for Postgresql I have a table and my app inserts rows to that table. It could be 2-3 rows, also it could be 100-200k rows. How to do that auto vacuum runs for that table as soon as possible? ...
0
votes
2
answers
390
views
Sensible value for autovacuum_cost_delay
I'm running a data warehouse on an AWS RDS PostgreSQL instance. Most of the heavy lifting is done during the night-batch, and very often we use a TRUNCATE-rebuild strategy, also for large tables (100M ...
0
votes
1
answer
199
views
What's the difference between autovacuum general setting and autovacuum_enabled table setting in PostgreSQL?
We have a database that is now on v15 PostgreSQL, but was recently migrated from v11, and before that v9. I believe that many of the settings for our database were preserved from prior versions and ...
4
votes
1
answer
2k
views
High CPU load after massive delete on PostgreSQL server
I've deleted ~65 million rows from a PostgreSQL table with ~75 million rows.
As soon as the deletion query completed, the CPU plummeted to 100% for about five minutes.
The table from which rows were ...
0
votes
2
answers
50
views
Suprising gained disk space after backup & restore PostgreSQL databases
We backed up, deleted and restored several databases. Surprisingly, the databases occupy 20% less storage space afterwards. Have we lost data or what could have happened here? Autovacuum runs ...
0
votes
2
answers
651
views
PostgreSQL query using BRIN index is slow until REINDEX/VACUUM
PostgreSQL 15.2. I have a partitioned table like this:
create table event
(
dataset_id integer not null,
event_id integer not null,
second_offset integer not null,
-- other columns
) ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
postgresql × 88
vacuum × 28
postgresql-9.6 × 9
performance × 8
locking × 5
postgresql-9.4 × 5
postgresql-12 × 4
maintenance × 4
amazon-rds × 4
disk-space × 2
optimization × 2
postgresql-11 × 2
postgresql-10 × 2
transaction × 2
replication × 2
update × 1
unaccent × 1
redshift × 1
timescaledb × 1
system-tables × 1
statistics × 1
standby × 1
sqlite3 × 1
more related tags
Hot Network Questions
- EU/USA trade deal - is it really a done deal?
- Rotate table with caption on same page as chapter title
- Why is aid being airdropped into Gaza?
- Is it ethical to hire a graphic designer for a job talk?
- How was the Universal Pictures 1936 opening logo created?
- Why do C compilers still prefer push over mov for saving registers, even when mov appears faster in llvm-mca?
- Uniqueness of multiple unnamed namespaces within translation unit
- Does intersubjectivity legitimize falsehoods?
- How to upgrade Ubuntu's minor version?
- Identify Last-Layer Perm of a Rubik's Cube
- "One can" in technical writing--good, bad, indifferent?
- How should I talk about definitional uncertainty in seemingly well-defined measurands, arising at high resolutions?
- Why emphasize seeking wisdom as "silver” rather than gold?
- Short story about a scientific rivalry that leads to madness
- How to create a Face Group from selected faces, similar to a Vertex Group
- Right size rim tape when converting MTB to tubeless
- Can Trump sue South Park?
- Bell always pinging on slight jolts
- Why are collision manifold points created inside objects instead of on their surfaces?
- Command to give a dimension expression with an optional argument
- Interpretation of the lorentz-invarient transition rates (LI Fermi's Golden Rule)
- Ten minutes walk Vs ten minute walk
- Is Samson referred to/mentioned in the siddur/liturgy?
- If Satan is not omnipresent, how can he tempt or test multiple people at the same time in different places?