Thanks a lot Scott ... -----Original Message----- From: Scott Marlowe [mailto:scott.marlowe@xxxxxxxxx] Sent: Saturday, October 02, 2010 3:14 AM To: tamanna madaan Cc: Michael Glaesemann; pgsql-general@xxxxxxxxxxxxxx Subject: Re: error while autovacuuming On Fri, Oct 1, 2010 at 2:06 PM, tamanna madaan <tamanna.madan@xxxxxxxxxxxxxxx> wrote: > Hi All > > I am planning to upgrade postgres to avoid this autovacuum problem. > > From the release notes of postgres-8.1.x it seems this issue > has been solved in postgres-8.1.6 and hence upgrading > to latest 8.1 release i.e 8.1.21 will solve this issue. > > But I was just wondering if postgres-8.4 will also be having this fix > (as I couldn't find it in release notes of postgres-8.4). 8.4 has much better autovacuuming, seeing as it's multithreaded and you can have a lot more control over how it behaves. This fix is definitely in 8.4 and 8.3, or should I say the bug you hit was long gone by the time the 8.4 branch was cut. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general