Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Boes
Subject Re: pg_class.reltuples not reset by VACUUM?
Date
Msg-id 1049833801.4871.41.camel@takin.private.nexcerpt.com
Whole thread Raw
In response to Re: pg_class.reltuples not reset by VACUUM?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_class.reltuples not reset by VACUUM?  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Tim Ellis
Date:
Subject: Re: Help with setting Posgresql on Linux to work with ASP
Next
From: Stephan Szabo
Date:
Subject: Re: How does PostgreSQL treat null values in unique composite