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 6F9C4D1D453; Sat, 22 Nov 2003 21:36:17 +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 07852-03; Sat, 22 Nov 2003 17:35:48 -0400 (AST) Received: from sunsite.dcc.uchile.cl (sunsite.dcc.uchile.cl [192.80.24.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1273ED1D5FD; Sat, 22 Nov 2003 17:35:45 -0400 (AST) Received: from root@anakena.dcc.uchile.cl [192.80.24.3] by sunsite.dcc.uchile.cl (8.8.5/Main-DCCV8-Jo6) id SAA09191; Sat, 22 Nov 2003 18:35:32 -0300 (CDT) Received: from alvherre@localhost by anakena.dcc.uchile.cl (8.8.5/MainSec-DCCV8-Jo5) id LAA07875; Sat, 22 Nov 2003 11:46:37 -0300 (CLST) Date: Sat, 22 Nov 2003 11:46:37 -0300 From: Alvaro Herrera Munoz To: "Matthew T. O'Connor" Cc: Josh Berkus , Robert Treat , Shridhar Daithankar , pgsql-performance@postgresql.org, PostgreSQL-development Subject: Re: [HACKERS] More detail on settings for pgavd? Message-ID: <20031122144637.GC6016@dcc.uchile.cl> References: <200311181558.45847.josh@agliodbs.com> <1069424054.29672.12462.camel@camel> <3FBE21D5.20508@zeut.net> <200311210909.00978.josh@agliodbs.com> <3FBE8289.1040009@zeut.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3FBE8289.1040009@zeut.net> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/222 X-Sequence-Number: 4782 On Fri, Nov 21, 2003 at 04:24:25PM -0500, Matthew T. O'Connor wrote: > I don't want to add tables to existing databases, as I consider that > clutter and I never like using tools that clutter my production > databases. [...] > > Actually, this might be a necessary addition as pg_autovacuum currently > suffers from the startup transients that the FSM used to suffer from, > that is, it doesn't remember anything that happened the last time it > ran. A pg_autovacuum database could also be used to store thresholds > and counts from the last time it ran. You could use the same approach the FSM uses: keep a file with the data, PGDATA/base/global/pg_fsm.cache. You don't need the data to be in a table after all ... -- Alvaro Herrera () Essentially, you're proposing Kevlar shoes as a solution for the problem that you want to walk around carrying a loaded gun aimed at your foot. (Tom Lane)