Re: Vacuum analyze decreases speed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David M(dot) Richter" <d(dot)richter(at)dkfz(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Vacuum analyze decreases speed
Date: 2001-12-07 17:11:46
Message-ID: 761.1007745106@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"DELETE FROM pg_statistic" should get you back where you were before
VACUUM ANALYZE.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Edipo Elder Fernandes de Melo 2001-12-07 17:34:51 Just comments about math
Previous Message David M. Richter 2001-12-07 15:39:51 Vacuum analyze decreases speed