pg_autovacuum exceptions question

From: Chris Bowlby <excalibur(at)accesswave(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_autovacuum exceptions question
Date: 2009-08-17 16:22:42
Message-ID: 4A8983D2.6080404@accesswave.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2009-08-17 16:35:23 Re: ERROR: attempted to delete invisible tuple
Previous Message Alvaro Herrera 2009-08-17 16:02:03 Re: Function Logging