All Questions

Tagged with
Filter by
Sorted by
Tagged with
2
votes
0answers
98 views

How do I fix multixact wraparound after it has already occurred?

I have a database which has a single table for which MultiXact wraparound has already occurred. Neither manual vacuums nor automatic vacuums are able to fix this condition. Manual vacuums fail almost ...
0
votes
1answer
23 views

Postgres VACUUM taking forever

I have an specific table that is taking forever o VACUUM. There are no locks in the DB and even letting it overnight the VACUUM didn't finish. According to the statistics (ANALYZE works fine) the ...
0
votes
1answer
39 views

Small databases, large backup files

We have PostgreSQL 9.6 databases and a dailytask running a pg_dump for all databases, though these backups are getting "large" at this point. My database was 900MB, then I tried clearing it by ...
1
vote
1answer
387 views

autovacuum challenges after upgrade to postgresql 9.6

We have a cluster with several dozen databases. It was running great on 9.3 for a year (growing over time) when we did the upgrade to 9.6 last month. Since that time, the database will freeze on ...
3
votes
1answer
3k views

Is VACUUM FULL necessary on a DROP TABLE / TRUNCATE approach for a datawarehouse

We are updating a datawarehouse on a weekly basis using a series of TRUNCATE source_table1 COPY source_table1 FROM [...] ... for data import and: DROP TABLE IF EXISTS my_table CREATE TABLE ...