Re: pg_class.reltuples not reset by VACUUM?

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_class.reltuples not reset by VACUUM?
Date: 2003-04-10 20:42:43
Message-ID: 1050007363.13305.44.camel@takin.private.nexcerpt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 2003-04-10 at 14:51, Robert Treat wrote:
> Out of curiosity, are you doing non-superuser vacuums on 7.2.3 or older
> system?
>

And I probably didn't answer your question. The username used to
perform all VACUUMs is marked "usesuper = t" in pg_shadow. I interpret
that as a superuser. Am I right?

--
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 Gary Dunn 2003-04-11 05:30:53 Re: Upgrading: So now you tell me!!?!?
Previous Message Jeff Boes 2003-04-10 20:34:56 Re: pg_class.reltuples not reset by VACUUM?