Jean-Christophe ARNU writes: > we use postgresql 7.2 for a data logging/supervisor application running > 24 hours a day, 7 days a week and 365 (and 6 hours) a year. Data are > inserted/deleted/updated each 1,5 minutes and for performance reason we > have to vacuum each day some tables. The problem is that vacuum stops > inserts, updates and deletes for the table it performs
As of 7.2, this is no longer true. I recommend you read section 8.2 of the Administrator's Guide. -- Peter Eisentraut [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
