Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB7HBgm89466 for ; Fri, 7 Dec 2001 12:11:42 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fB7HBki00764; Fri, 7 Dec 2001 12:11:46 -0500 (EST) To: "David M. Richter" cc: pgsql-sql@postgresql.org Subject: Re: Vacuum analyze decreases speed In-reply-to: <3C10E2C7.BA8D361D@dkfz.de> References: <3C10E2C7.BA8D361D@dkfz.de> Comments: In-reply-to "David M. Richter" message dated "Fri, 07 Dec 2001 16:39:51 +0100" Date: Fri, 07 Dec 2001 12:11:46 -0500 Message-ID: <761.1007745106@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200112/90 X-Sequence-Number: 5913 "DELETE FROM pg_statistic" should get you back where you were before VACUUM ANALYZE. regards, tom lane