Herouth Maoz <herouth@unicell.co.il> 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