Re: un-'vacuum analyse'

From: Tom Lane
Subject: Re: un-'vacuum analyse'
Date: ,
Msg-id: 8960.1143822430@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: un-'vacuum analyse'  (Frederic Back)
List: pgsql-performance

Frederic Back <> writes:
> Is there a way to de-'vacuum analyse' a database for
> testing purposes?

"DELETE FROM pg_statistic" will get you most of the way there.
It doesn't get rid of the accurate relpages/reltuples entries
in pg_class, but since CREATE INDEX also updates those counts,
I think it's reasonable to consider that a freshly loaded database
would normally have correct counts.

            regards, tom lane


pgsql-performance by date:

From: Antoine
Date:
Subject: Re: [Solved] Slow performance on Windows .NET and OleDb
From: "Magnus Hagander"
Date:
Subject: Re: [Solved] Slow performance on Windows .NET and OleDb