Re: Vacuum full? - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuum full?
Date
Msg-id 29181.1036704193@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum full?  (Dmitry Tkach <dmitry@openratings.com>)
List pgsql-general
Dmitry Tkach <dmitry@openratings.com> writes:
> By closing other transactions, did you mean ALL transactions open in
> that database, or just the ones, having anything to do with that table
> (reading/writing)?

I mean ALL.

You can start some new ones right away, but your current open
transactions are determining what VACUUM thinks might be a still-visible
tuple.  You need to make the "oldest open transaction number" move
forward.

            regards, tom lane

pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: PostgreSQL on Linux and Solaris comparison
Next
From: Neil Conway
Date:
Subject: Re: request new feature: auto recompile of function when oid not found