Re: autovacuum and temporary tables

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Cc: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: autovacuum and temporary tables
Date: 2006-01-20 15:05:29
Message-ID: 43D0FC39.6070704@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Exactly which version of 8.0.x? There was a bug fixed around 8.0.5 or
so "Prevent core dump in contrib version of autovacuum when a table has
been dropped. Per report from daveg (not his patch, though)."

The version of autovacuum in 8.1 is a fairly different beast than the
contrib version, and since it was integrated, I think all of Tom's
concerns were dealt with. I highly recommend the 8.1 version over the
contrib version for many reason.

Matt

Csaba Nagy wrote:
> Hi all,
>
> I have a postgres 8.0 installation, and I'm running autovacuum against
> it. I have noticed that it processes temporary tables too, which is in
> itself a bit curious, but the problem is that autovacuum might even
> crash if a temporary table is suddenly gone while it tries to vacuum
> it... that's what happened once here. I'm not sure what are the
> necessary conditions to trigger this, it only happened once.
>
> I searched in the release notes and googled a bit, but could not
> (quickly) find what's the status of autovacuum vs. temporary tables in
> 8.1. I have seen that that was one of Tom's outstanding issues with
> autovacuum to be included in the core, but was this resolved ?
>
> Thanks,
> Csaba.
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2006-01-20 15:09:57 Re: Create User
Previous Message Tom Lane 2006-01-20 14:56:04 Re: Initdb panic: invalid record offset at 0/0 creating template1]