X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 953479FA646 for ; Wed, 5 Jul 2006 12:57:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 81195-02 for ; Wed, 5 Jul 2006 12:57:28 -0300 (ADT) X-Greylist: delayed 02:50:31.053161 by SQLgrey- Received: from office.redwerk.com (office.redwerk.com [85.90.206.104]) by postgresql.org (Postfix) with ESMTP id 5F3149FA0EC for ; Wed, 5 Jul 2006 12:57:28 -0300 (ADT) Received: from bofh by office.redwerk.com with local (Exim 4.62 (FreeBSD)) (envelope-from ) id 1Fy9kl-00040P-BZ for pgsql-performance@postgresql.org; Wed, 05 Jul 2006 18:57:27 +0300 Date: Wed, 5 Jul 2006 18:57:27 +0300 From: Eugeny N Dzhurinsky To: pgsql-performance@postgresql.org Subject: Re: managing database with thousands of tables Message-ID: <20060705155727.GC15232@office.redwerk.com> References: <20060705130703.GA2428@office.redwerk.com> <2955.1152106771@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline In-Reply-To: <2955.1152106771@sss.pgh.pa.us> User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/29 X-Sequence-Number: 19889 On Wed, Jul 05, 2006 at 09:39:31AM -0400, Tom Lane wrote: > Eugeny N Dzhurinsky writes: > > but it seems pg_autovacuum does not do vacuuming on system tables. > > There was a bug awhile back whereby autovac failed to notice temp table > cleanup at connection end --- maybe you need to update? May be. So should I update to newer postgres 8.1 or just upgrade pg_autovacuum somehow (I don't know how btw ;) )? -- Eugene N Dzhurinsky