X-Original-To: pgsql-performance@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id C76D7475B85
	for <pgsql-performance@postgresql.org>;
	Wed, 30 Apr 2003 21:51:39 -0400 (EDT)
Received: from houston.familyhealth.com.au (unknown [203.59.48.253])
	by postgresql.org (Postfix) with ESMTP id E5D0C475A45
	for <pgsql-performance@postgresql.org>;
	Wed, 30 Apr 2003 21:51:37 -0400 (EDT)
Received: (from root@localhost)
	by houston.familyhealth.com.au (8.11.6p2/8.11.6) id h411pep53708
	for pgsql-performance@postgresql.org;
	Thu, 1 May 2003 09:51:40 +0800 (WST)
	(envelope-from chriskl@familyhealth.com.au)
Received: from mariner (mariner.internal [192.168.0.101])
	by houston.familyhealth.com.au (8.11.6p2/8.9.3) with SMTP id
	h411pWJ53573; Thu, 1 May 2003 09:51:32 +0800 (WST)
Message-ID: <0a1301c30f84$39a2dbe0$6500a8c0@fhp.internal>
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: <josh@agliodbs.com>,
	"Achilleus Mantzios" <achill@matrix.gatewaynet.com>
Cc: <pgsql-performance@postgresql.org>
References: <Pine.LNX.4.44.0304301907560.8921-100000@matrix.gatewaynet.com>
	<200304301148.18322.josh@agliodbs.com>
Subject: Re: [SQL] 7.3 analyze & vacuum analyze problem
Date: Thu, 1 May 2003 09:51:41 +0800
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-scanner: scanned by Inflex 0.1.5c - (http://www.inflex.co.za/)
X-Spam-Status: No, hits=-13.4 required=5.0
	tests=BAYES_20,QUOTED_EMAIL_TEXT,QUOTE_TWICE_1,REFERENCES
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/273
X-Sequence-Number: 1779

> > I am afraid it is not so simple.
> > What i (unsuccessfully) implied is that
> > dynacom=# VACUUM ANALYZE status ;
> > VACUUM
> > dynacom=# ANALYZE status ;
> > ANALYZE
> > dynacom=#
>
> You're right, that is mysterious.   If you don't get a response from one
of
> the major developers on this forum, I suggest that you post those EXPLAIN
> results to PGSQL-BUGS.

Is it mysterious?  The ANALYZE histogram algorithm does do random sampling
doesn't it?

Chris