Re: error while autovacuuming

Thanks a lot Scott ...

-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Saturday, October 02, 2010 3:14 AM
To: tamanna madaan
Cc: Michael Glaesemann; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] error while autovacuuming

On Fri, Oct 1, 2010 at 2:06 PM, tamanna madaan
<tamanna(dot)madan(at)globallogic(dot)com> 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.