Re: pg_autovacuum exceptions question

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Chris Bowlby <excalibur(at)accesswave(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_autovacuum exceptions question
Date: 2009-08-17 17:09:33
Message-ID: 20090817170933.GH4782@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chris Bowlby wrote:
> Hi Guys,
>
> In relation to pg_autovacuum, I have a quick question, that I can't seem
> to find an answer to anywhere. I use a temporary database that only
> exists when certain scripts are running, and is dropped when the scripts
> are complete. In that process, I have seen pg_autovacuum periodically
> examine that database, it really is not necessary for it to do so.
>
> I was wondering if there was a way to prevent pg_autovacuum from doing
> that via an exception list? Such that I can insert the name of this
> database into a system catalog, or even a string entry in the
> postgresql.conf file and not have that database examined?

I don't think you can disable autovacuum for individual databases, but
in any case the check should be fairly quick and it should bail out
without doing much.

If we wanted to support this feature, the way to do it would be to add
an option in pg_database or something like that, not the config file.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-08-17 17:17:08 Re: ERROR: attempted to delete invisible tuple
Previous Message Bryan Murphy 2009-08-17 17:07:59 Re: ERROR: attempted to delete invisible tuple