Top "Vacuum" questions

In SQLite and PosgreSQL, the VACUUM command rebuilds the entire database.

postgreSQL vacuum temp files?

I've got a "little" problem. A week ago my database was reaching full disk capacity. I deleted many rows in …

postgresql diskspace vacuum
Amazon Redshift at 100% disk usage due to VACUUM query

Reading the Amazon Redshift documentatoin I ran a VACUUM on a certain 400GB table which has never been vacuumed before, …

amazon-web-services amazon-redshift vacuum
PostgreSQL: How to enable autovacuum?

How does one enable autovacuum in PostgreSQL? I understand the purpose, I just can't find a simple answer regarding how …

postgresql database-administration vacuum autovacuum
How to efficiently vacuum analyze tables in Postgres

I had a huge query running on postgres and one of the join tables always did a sequential scan. The …

sql postgresql vacuum
Postgresql: database is not accepting commands to avoid wraparound data loss

Got the error upon create/delete/update queries: ERROR: database is not accepting commands to avoid wraparound data loss in …

database postgresql rdbms vacuum
PostgreSQL Long VACUUM

I am currently cleaning up a table with 2 indexes and 250 million active rows and approximately as many dead rows (or …

postgresql rdbms vacuum