X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5A138D1B520; Fri, 21 Nov 2003 15:07:40 +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 92477-07; Fri, 21 Nov 2003 11:07:13 -0400 (AST) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [192.108.102.143]) by svr1.postgresql.org (Postfix) with ESMTP id 97813D1D7BD; Fri, 21 Nov 2003 11:07:08 -0400 (AST) Received: from myrealbox.com shridhar_daithankar@smtp-send.myrealbox.com [202.54.11.72] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 3.44 $ on Novell NetWare via secured & encrypted transport (TLS); Fri, 21 Nov 2003 08:07:04 -0700 Message-ID: <3FBE2A0E.3010308@myrealbox.com> Date: Fri, 21 Nov 2003 20:36:54 +0530 From: Shridhar Daithankar User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Matthew T. O'Connor" Cc: Josh Berkus , Shridhar Daithankar , pgsql-performance@postgresql.org, PostgreSQL-development Subject: Re: [HACKERS] More detail on settings for pgavd? References: <200311181558.45847.josh@agliodbs.com> <200311200918.30838.josh@agliodbs.com> <3FBD5EEF.7060205@zeut.net> <200311202224.45065.josh@agliodbs.com> <3FBE2791.8040404@zeut.net> In-Reply-To: <3FBE2791.8040404@zeut.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/189 X-Sequence-Number: 4749 Matthew T. O'Connor wrote: > But we track tuples because we can compare against the count given by > the stats system. I don't know of a way (other than looking at the FSM, > or contrib/pgstattuple ) to see how many dead pages exist. I think making pg_autovacuum dependent of pgstattuple is very good idea. Probably it might be a good idea to extend pgstattuple to return pages that are excessively contaminated and clean them ASAP. Step by step getting closer to daemonized vacuum. Shridhar