| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Jeff Boes <jboes(at)nexcerpt(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: pg_class.reltuples not reset by VACUUM? |
| Date: | 2003-04-10 18:51:57 |
| Message-ID: | 1050000717.23437.404.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Boes | 2003-04-10 20:34:56 | Re: pg_class.reltuples not reset by VACUUM? |
| Previous Message | Tim Ellis | 2003-04-10 18:13:05 | Re: PLEASE HELP ME URGENT about choosing only the ones |