X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DC2D3D1CA5C; Thu, 20 Nov 2003 16:33:27 +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 64936-02; Thu, 20 Nov 2003 12:32:57 -0400 (AST) Received: from mta9.srv.hcvlny.cv.net (mta9.srv.hcvlny.cv.net [167.206.5.42]) by svr1.postgresql.org (Postfix) with ESMTP id 84379D1C991; Thu, 20 Nov 2003 12:32:38 -0400 (AST) Received: from zeut.net (ool-4352919e.dyn.optonline.net [67.82.145.158]) by mta9.srv.hcvlny.cv.net (iPlanet Messaging Server 5.2 HotFix 1.16 (built May 14 2003)) with ESMTP id <0HON00D7QSLWVA@mta9.srv.hcvlny.cv.net>; Thu, 20 Nov 2003 11:32:22 -0500 (EST) Date: Thu, 20 Nov 2003 11:32:24 -0500 From: "Matthew T. O'Connor" Subject: Re: [PERFORM] More detail on settings for pgavd? In-reply-to: <200311202029.47351.shridhar_daithankar@myrealbox.com> To: Shridhar Daithankar Cc: Josh Berkus , pgsql-performance@postgresql.org, PostgreSQL-development Message-id: <3FBCEC98.4080309@zeut.net> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 References: <200311181558.45847.josh@agliodbs.com> <3FBC6BED.9090809@myrealbox.com> <3FBCD013.3030402@zeut.net> <200311202029.47351.shridhar_daithankar@myrealbox.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/1130 X-Sequence-Number: 47418 Shridhar Daithankar wrote: >On Thursday 20 November 2003 20:00, Matthew T. O'Connor wrote: > > >>Shridhar Daithankar wrote: >> >> >>>I am still wary of inverting vacuum analyze frequency. You think it is >>>better to set inverted default rather than documenting it? >>> >>> >>I think inverting the vacuum and analyze frequency is wrong. >> >> >Me. Too. ATM all I can think of this patch attached. Josh, is it sufficient >for you?..:-) > > The patch just adds an example to the README, this looks ok to me. >Matthew, I am confyused about one thing. Why would autovacuum count updates >while checking for analyze threshold? Analyze does not change statistics >right? ( w.r.t line 1072, pg_autovacuum.c). For updating statistics, only >inserts+deletes should suffice, isn't it? > > An update is the equivelant of an insert and a delete, so it counts towards the analyze count as much as an insert. >Other than that, I think autovacuum does everything it can. > > It could be more customizable.