[PERFORM] VACUUM Performance

2006-10-20 Thread Steve Oualline
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

[PERFORM] Database restore speed

2005-12-01 Thread Steve Oualline
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