Michael Fuhr <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
