Herouth Maoz <herouth@xxxxxxxxxxxxx> wrote: > On 10/12/2013, at 20:55, Kevin Grittner wrote: >> First, make sure that you are on the latest minor release of >> whatever major release you are running. There were some serious >> problems with autovacuum's table truncation when a table was >> used as a queue and size fluctuated. These are fixed in the >> latest set of minor releases. > > I failed to mention which version of PostgreSQL I was on. > 9.1.2 in this case. Do you mean that I have to go to 9.3.x or > simply to 9.1.11? In the PostgreSQL world, a minor release is when everything to the left of the second dot stays the same. http://www.postgresql.org/support/versioning/ 9.1.11 contains the fix for the problems I was describing. While it's a good idea to stay current with minor releases in general, for those using a table for a queue which may fluctuate in size, there is an important set of fixes that make it particularly important right now. I have seen multiple sites using Slony where, without the fixes, the database became unusable for normal production after falling behind and subsequently catching up. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
