Re: un-vacuum? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: un-vacuum?
Date
Msg-id 9793.1137708716@sss.pgh.pa.us
Whole thread Raw
In response to Re: un-vacuum?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-hackers
Michael Fuhr <mike@fuhr.org> writes:
> On Thu, Jan 19, 2006 at 03:54:33PM -0500, uwcssa wrote:
>> I want to do this for  repeating some experiment results, not for
>> tuning the db (pretty much like using an old machine to find
>> performance difference for an algorithm).  so if i have a way
>> of knowing which tables are storing the statistics, i guess i can
>> delete all from that table to archieve this.

> pg_statistic stores statistics.  I think it's safe to delete rows,

"DELETE FROM pg_statistic" is safe enough, but it's more of an
"un-analyze" than an "un-vacuum".  There is no "un-vacuum".
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Cache-flush stress testing
Next
From: Andrew - Supernews
Date:
Subject: Bug: random() can return 1.0