X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CCA9A9DCD5D for ; Thu, 1 Dec 2005 13:07:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80880-05 for ; Thu, 1 Dec 2005 13:07:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.refusion.com (mail.refusion.com [213.144.155.20]) by postgresql.org (Postfix) with ESMTP id 643EB9DCB7B for ; Thu, 1 Dec 2005 13:07:52 -0400 (AST) Received: from iwing by mail.refusion.com (MDaemon.PRO.v8.1.0.R) with ESMTP id md50000409864.msg for ; Thu, 01 Dec 2005 18:07:51 +0100 Message-ID: <06f401c5f699$bbae2af0$0201a8c0@iwing> From: To: "Michael Riess" , References: Subject: Re: 15,000 tables Date: Thu, 1 Dec 2005 18:07:37 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.3790.1830 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 X-Authenticated-Sender: info@alternize.com X-Spam-Processed: mail.refusion.com, Thu, 01 Dec 2005 18:07:51 +0100 (not processed: message from trusted or authenticated source) X-MDRemoteIP: 80.238.204.232 X-Return-Path: me@alternize.com X-MDaemon-Deliver-To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=3.423 required=5 tests=[DNS_FROM_RFC_DSN=2.872, NO_REAL_NAME=0.55, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 3.423 X-Spam-Level: *** X-Archive-Number: 200512/27 X-Sequence-Number: 15848 hi michael >> Have you ANALYZEd your database? VACUUMing? > > Of course ... before 8.1 we routinely did a vacuum full analyze each > night. As of 8.1 we use autovacuum. what i noticed is autovacuum not working properly as it should. i had 8.1 running with autovacuum for just 2 days or so and got warnings in pgadmin that my tables would need an vacuum. i've posted this behaviour some weeks ago to the novice list requesting more infos on how to "tweak" autovacuum properly - unfortunately without any respones. thats when i switched the nightly analyze job back on - everything runs smooth since then. maybe it helps in your case as well? cheers, thomas