Re: pg_class.reltuples not reset by VACUUM? - Mailing list pgsql-admin

From Robert Treat
Subject Re: pg_class.reltuples not reset by VACUUM?
Date
Msg-id 1050000717.23437.404.camel@camel
Whole thread Raw
In response to Re: pg_class.reltuples not reset by VACUUM?  (Jeff Boes <jboes@nexcerpt.com>)
Responses Re: pg_class.reltuples not reset by VACUUM?
Re: pg_class.reltuples not reset by VACUUM?
List pgsql-admin
Out of curiosity, are you doing non-superuser vacuums on 7.2.3 or older
system?

Robert Treat

On Tue, 2003-04-08 at 16:30, Jeff Boes wrote:
> On Tue, 2003-04-08 at 15:19, Tom Lane wrote:
>
> > > This appears to happen even if there are no transactions open.
> >
> > You have open transactions.  Go find 'em...
> >
>
> Hmm.  Maybe, maybe not.  After I shut down everything, I got
>
> "Parent tuple not found"
>
> errors.  I bounced the database, and it cleared up.
>
> --
> Jeff Boes                                      vox 269.226.9550 ext 24
> Database Engineer                                     fax 269.349.9076
> Nexcerpt, Inc.                                 http://www.nexcerpt.com
>            ...Nexcerpt... Extend your Expertise
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


pgsql-admin by date:

Previous
From: Tim Ellis
Date:
Subject: Re: PLEASE HELP ME URGENT about choosing only the ones
Next
From: Jeff Boes
Date:
Subject: Re: pg_class.reltuples not reset by VACUUM?