Re: Vaccum and 24/7/365 database - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Vaccum and 24/7/365 database
Date
Msg-id Pine.LNX.4.30.0201091117560.734-100000@peter.localdomain
Whole thread Raw
In response to Vaccum and 24/7/365 database  (Jean-Christophe ARNU <jc.arnu@free.fr>)
List pgsql-admin
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   peter_e@gmx.net


pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Vaccum and 24/7/365 database
Next
From: Trevor Astrope
Date:
Subject: Performance Tuning