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 E77C5D1B54C; Thu, 20 Nov 2003 23:19:12 +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 32640-08; Thu, 20 Nov 2003 19:18:43 -0400 (AST) Received: from mta1.srv.hcvlny.cv.net (mta1.srv.hcvlny.cv.net [167.206.5.67]) by svr1.postgresql.org (Postfix) with ESMTP id 403E4D1B520; Thu, 20 Nov 2003 19:18:40 -0400 (AST) Received: from zeut.net (ool-4352919e.dyn.optonline.net [67.82.145.158]) by mta1.srv.hcvlny.cv.net (iPlanet Messaging Server 5.2 HotFix 1.16 (built May 14 2003)) with ESMTP id <0HOO004BHBF8UT@mta1.srv.hcvlny.cv.net>; Thu, 20 Nov 2003 18:18:49 -0500 (EST) Date: Thu, 20 Nov 2003 18:18:27 -0500 From: "Matthew T. O'Connor" Subject: Re: [HACKERS] More detail on settings for pgavd? In-reply-to: <6000.1069356024@sss.pgh.pa.us> To: Tom Lane Cc: Chester Kustarz , Josh Berkus , pgsql-performance@postgresql.org, PostgreSQL-development Message-id: <3FBD4BC3.8030003@zeut.net> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; 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: <6000.1069356024@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/220 X-Sequence-Number: 4780 Tom Lane wrote: >Chester Kustarz writes: > > >>vacuum is to reclaim dead tuples. this means it depends on update and >>delete. analyze depends on data values/distribution. this means it depends on >>insert, update, and delete. thus the dependencies are slightly different >>between the 2 operations, an so you can come up with use-cases that >>justify running either more frequently. >> >> >Agreed. > > And that is why pg_autovacuum looks at insert, update and delete when deciding to do an analyze, but only looks at update and delete when deciding to do a vacuum. In addition, this is why pg_autovacuum was given knobs so that the vacuum and analyze thresholds can be set independently. Matthew