The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
38 views

In PostgreSQL, will VACUUM reset the dead tuple count (n_dead_tup in pg_stat_all_tables)?

In PostgreSQL, will VACUUM reset the dead tuple count (n_dead_tup in pg_stat_all_tables)? The situation I'm seeing is that vacuum is apparently being run manually, once daily, and the n_dead_tup / ...
3
votes
0answers
363 views

Stubborn autovacuum process slow things dows

We are facing a strange problem since yesterday. In a database of ours there is a partitioned table containing historical data. That is, every week's data goes to a different partition and stays ...
1
vote
0answers
240 views

Amazon Redshift VACUUM error

I'm trying to run vacuum delete only on a table with big amount of columns (800+) and 4 million rows. I know it's recommended to use deep copy instead, but still am wondering if running vacuum is ...
1
vote
0answers
136 views

Postgresql 9.2 - Auto vacuum running continuously for 18+ hours

I currently have a table that is updated daily (easily 20%+ rows are updated, all floats/integers) and the vacuum is kicking off and running for more than 18 hours. There are 19 million rows total. ...
0
votes
0answers
26 views

Is it possible to do a VACUUM FULL and allow read-only access to the table?

I have a PostgreSQL (9.3ish) database which has a lot of data written to it frequently. Disk space is constantly being used. I have had success with VACUUM FULL with trimming the bloat and reducing ...
0
votes
0answers
50 views

Why “0 pages are entirely empty” after mass delete + vacuum?

I have a huge table for logging the user actions (audit log) in my PostgreSQL 9.4 database. It gets about 100 new records per second. I've removed very old records recently. I assume this affected a ...