X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 79B0ED1B545; Thu, 20 Nov 2003 18:01:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 78548-04; Thu, 20 Nov 2003 14:01:01 -0400 (AST) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 1BCAFD1C9E5; Thu, 20 Nov 2003 14:01:00 -0400 (AST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3950317; Thu, 20 Nov 2003 10:01:45 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Shridhar Daithankar Subject: Re: More detail on settings for pgavd? Date: Thu, 20 Nov 2003 10:00:34 -0800 User-Agent: KMail/1.4.3 Cc: pgsql-performance@postgresql.org, PostgreSQL-development References: <200311181558.45847.josh@agliodbs.com> <200311190906.15828.josh@agliodbs.com> <3FBC6BED.9090809@myrealbox.com> In-Reply-To: <3FBC6BED.9090809@myrealbox.com> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200311201000.34694.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/176 X-Sequence-Number: 4736 Shridhar, > I would say -V 0.2-0.4 could be great as well. Fact to emphasize is that > thresholds less than 1 should be used. Yes, but not thresholds, scale factors of less than 1.0. Thresholds should still be in the range of 100 to 1000. > I will submit a patch that would account deletes in analyze threshold. > Since you want to delay the analyze, I would calculate analyze count as > > n=updates + inserts *-* deletes I'm not clear on how this is a benefit. Deletes affect the statistics, too. > What does statistics gather BTW? Just number of rows or something else as > well? I think I would put that on Hackers separately. Number of tuples, degree of uniqueness, some sample values, and high/low values. Just query your pg_statistics view for an example. > I am still wary of inverting vacuum analyze frequency. You think it is > better to set inverted default rather than documenting it? See my post to Matthew. -- Josh Berkus Aglio Database Solutions San Francisco