Re: [ADMIN] Very busy 24x7 databases and VACUUM

2004-12-05 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] ("David F. Skoll") wrote: > Does anyone run a very busy PostgreSQL datatabase, with lots of read > and write operations that run 24x7? (We're talking on the > neighbourhood of 40 to 60 queries/second, with probably 5% to 10% of > them being INSERT or

[ADMIN] Very busy 24x7 databases and VACUUM

2004-12-05 Thread David F. Skoll
Hi, Does anyone run a very busy PostgreSQL datatabase, with lots of read and write operations that run 24x7? (We're talking on the neighbourhood of 40 to 60 queries/second, with probably 5% to 10% of them being INSERT or UPDATE.) Some of our clients run such a DB, and the nightly VACUUM slows th