Re: pg_class.reltuples not reset by VACUUM?

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_class.reltuples not reset by VACUUM?
Date: 2003-04-08 20:30:01
Message-ID: 1049833801.4871.41.camel@takin.private.nexcerpt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-04-08 20:41:19 Re: How does PostgreSQL treat null values in unique composite
Previous Message Tim Ellis 2003-04-08 20:10:34 Re: Help with setting Posgresql on Linux to work with ASP