Re: Need help with corrupt pg_statistic - Mailing list pgsql-admin

From Tom Lane
Subject Re: Need help with corrupt pg_statistic
Date
Msg-id 10288.1128304882@sss.pgh.pa.us
Whole thread Raw
In response to Need help with corrupt pg_statistic  (Kevin Seghetti <kts@tenetti.org>)
List pgsql-admin
Kevin Seghetti <kts@tenetti.org> writes:
> Is there any way to nuke pg_statistic (since its contents can be
> recalculated anyway?)

You want to do "TRUNCATE pg_statistic"; to avoid the permission check,
you'll need to do that in a standalone backend with -O option.

Do *not* try to drop and recreate it --- its OID is hardwired into
various places.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuum Full Analyze Stalled
Next
From: David Fetter
Date:
Subject: Re: [HACKERS] pgAdmin guru hints