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 2644E9DD699 for ; Thu, 1 Dec 2005 14:48:24 -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 26616-05 for ; Thu, 1 Dec 2005 14:48:19 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtpauth02.mail.atl.earthlink.net (smtpauth02.mail.atl.earthlink.net [209.86.89.62]) by postgresql.org (Postfix) with ESMTP id 3E3069DD695 for ; Thu, 1 Dec 2005 14:48:20 -0400 (AST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=dk20050327; d=earthlink.net; b=pxT3mWKxwxnHeyDJa+WwYioXdg+F0RoKHc0p2+O5d7RWPqW9IEO9LPUq03ErpPoU; h=Received:Message-Id:X-Mailer:Date:To:From:Subject:In-Reply-To:References:Mime-Version:Content-Type:X-ELNK-Trace:X-Originating-IP; Received: from [70.22.193.119] (helo=ron-6d52adff2a6.earthlink.net) by smtpauth02.mail.atl.earthlink.net with asmtp (Exim 4.34) id 1EhtTc-0002v7-2v; Thu, 01 Dec 2005 13:48:16 -0500 Message-Id: <6.2.5.6.0.20051201134344.035fed60@earthlink.net> X-Mailer: QUALCOMM Windows Eudora Version 6.2.5.6 Date: Thu, 01 Dec 2005 13:48:11 -0500 To: Tino Wildenhain ,pgsql-performance@postgresql.org From: Ron Subject: Re: 15,000 tables In-Reply-To: <1133462407.5734.43.camel@Andrea.peacock.de> References: <9A858930-1CA6-4238-92D4-D1E945683653@ehpg.net> <1133462407.5734.43.camel@Andrea.peacock.de> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-ELNK-Trace: acd68a6551193be5d780f4a490ca69563f9fea00a6dd62bcd113ec9ee20bae284c4783242b06a722350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 70.22.193.119 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.239 required=5 tests=[AWL=-0.239, DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.239 X-Spam-Level: X-Archive-Number: 200512/34 X-Sequence-Number: 15855 Agreed. Also the odds of fs corruption or data loss are higher in a non journaling fs. Best practice seems to be to use a journaling fs but to put the fs log on dedicated spindles separate from the actual fs or pg_xlog. Ron At 01:40 PM 12/1/2005, Tino Wildenhain wrote: >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 > > >---------------------------(end of broadcast)--------------------------- >TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq