X-Original-To: pgsql-admin@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id E119392578C for ; Thu, 22 May 2003 12:59:50 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 35819-08 for ; Thu, 22 May 2003 12:59:49 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by developer.postgresql.org (Postfix) with ESMTP id D600F9256A2 for ; Thu, 22 May 2003 11:51:44 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h4MFpXU6019529; Thu, 22 May 2003 11:51:33 -0400 (EDT) To: Robert.Farrugia@go.com.mt Cc: pgsql-admin@postgresql.org Subject: Re: After VACUUM, statistics become skewed In-reply-to: <20030522075734.C53F29234B3@developer.postgresql.org> References: <20030522075734.C53F29234B3@developer.postgresql.org> Comments: In-reply-to Robert.Farrugia@go.com.mt message dated "Thu, 22 May 2003 09:57:30 +0200" Date: Thu, 22 May 2003 11:51:32 -0400 Message-ID: <19528.1053618692@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/310 X-Sequence-Number: 8872 Robert.Farrugia@go.com.mt writes: > Here are the results. I asked for EXPLAIN ANALYZE for both cases. When you're worried about planner estimates diverging from reality, it does not help to not know what reality is. regards, tom lane