Re: error while autovacuuming

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: tamanna madaan <tamanna(dot)madan(at)globallogic(dot)com>
Cc: Michael Glaesemann <grzm(at)seespotcode(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: error while autovacuuming
Date: 2010-10-01 21:44:01
Message-ID: AANLkTi=aWhB-Kk3tUFuarNBb0o5ds53LFU77yYJ6bUDr@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tamanna madaan 2010-10-01 21:46:29 Re: error while autovacuuming
Previous Message Darren Duncan 2010-10-01 20:24:28 Re: Group By Question