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 5FC4C9FA605 for ; Wed, 5 Jul 2006 21:33: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 82574-06 for ; Wed, 5 Jul 2006 21:33:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.192]) by postgresql.org (Postfix) with ESMTP id 7BD779FA147 for ; Wed, 5 Jul 2006 21:33:26 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id 13so1537496nzp for ; Wed, 05 Jul 2006 17:33:25 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=Jiu9bKKlDWlVkfxopKaewvRvda9kVc0RtFqTCHQJffVefMQRn3gyYNY7KZXtnWh6CudXSh9lcxLXQAxPInFHhAKLk3QazYRBpRPapJbyNxvTs6Pmi/F9OLuD4iojQBhUQQ1+i0fh2eE79v+t4aTNet89efpikBZoyqH3O/haNq8= Received: by 10.36.47.14 with SMTP id u14mr33083nzu; Wed, 05 Jul 2006 17:33:25 -0700 (PDT) Received: from ?10.1.1.20? ( [203.217.18.65]) by mx.gmail.com with ESMTP id 12sm163906nzn.2006.07.05.17.33.22; Wed, 05 Jul 2006 17:33:24 -0700 (PDT) Message-ID: <44AC5A50.9000503@gmail.com> Date: Thu, 06 Jul 2006 10:33:20 +1000 From: Chris User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: Eugeny N Dzhurinsky CC: pgsql-performance@postgresql.org Subject: Re: managing database with thousands of tables References: <20060705130703.GA2428@office.redwerk.com> <2955.1152106771@sss.pgh.pa.us> <20060705155727.GC15232@office.redwerk.com> In-Reply-To: <20060705155727.GC15232@office.redwerk.com> Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/35 X-Sequence-Number: 19895 Eugeny N Dzhurinsky wrote: > 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 ;) )? Update the whole lot. You should be able to do the upgrade "in place" but take a backup "just in case". http://www.postgresql.org/docs/8.1/interactive/release.html will list all changes between versions. -- Postgresql & php tutorials http://www.designmagick.com/