Re: VACUUM FULL produce warnings

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: spied(at)yandex(dot)ru
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM FULL produce warnings
Date: 2004-06-10 14:32:42
Message-ID: 24406.1086877962@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

spied(at)yandex(dot)ru writes:
> look please http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=253295

I wouldn't worry about it. It's probably due to the fact that we tend
to release write lock on system catalogs immediately after updating the
catalog, instead of holding the lock till commit. That means it's
possible for VACUUM FULL to see uncommitted tuples in system catalogs,
which it should never do in user tables.

(This theory does assume that you are making system catalog changes
concurrently with running VACUUM, which doesn't entirely square with
your statement that database updates are "rare". Perhaps you create
and delete temp tables frequently?)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Milos Prudek 2004-06-10 15:17:11 Re: encrypted passwords
Previous Message Tom Lane 2004-06-10 14:22:14 Re: How to tell when postmaster is ready