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 1A7349DCD76 for ; Thu, 1 Dec 2005 14:40:18 -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 26800-02 for ; Thu, 1 Dec 2005 14:40:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from service-web.de (p15093784.pureserver.info [217.160.106.224]) by postgresql.org (Postfix) with ESMTP id 9A6159DCB7B for ; Thu, 1 Dec 2005 14:40:13 -0400 (AST) Received: from [192.168.178.99] (p548B3046.dip0.t-ipconnect.de [84.139.48.70]) by service-web.de (Postfix) with ESMTP id D96BC20002A; Thu, 1 Dec 2005 19:40:09 +0100 (CET) Subject: Re: 15,000 tables From: Tino Wildenhain To: "Gavin M. Roy" Cc: Michael Riess , pgsql-performance@postgresql.org In-Reply-To: <9A858930-1CA6-4238-92D4-D1E945683653@ehpg.net> References: <9A858930-1CA6-4238-92D4-D1E945683653@ehpg.net> Content-Type: text/plain Date: Thu, 01 Dec 2005 19:40:07 +0100 Message-Id: <1133462407.5734.43.camel@Andrea.peacock.de> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/33 X-Sequence-Number: 15854 Am Donnerstag, den 01.12.2005, 10:07 -0800 schrieb Gavin M. Roy: > Hi Michael, > > I'm a fan of ReiserFS, and I can be wrong, but I believe using a > journaling filesystem for the PgSQL database could be slowing things > down. Have a 200G+ database, someone pulling the power plug or a regular reboot after a year or so. Wait for the fsck to finish. Now think again :-) ++Tino