Title: VACUUM Performance
Question: I have a big table with 120,000,000 records.
Let's assume that I DELETE 4,000,000 records, VACUUM FULL, and REINDEX.
Now I have the same table, but with 240,000,000 records.
I DELETE 8,000,000 records, VACUUM FULL, and REINDEX.
Should the second
Title: Database restore speed
Our application tries to insert data into the database as fast as it can.
Currently the work is being split into a number of 1MB copy operations.
When we restore the postmaster process tries to use 100% of the CPU.
The questions we have are:
1) What is pos