Postgres Pro
Downloads
Home   >   mailing lists

Re: 15,000 tables - Mailing list pgsql-performance

From Tino Wildenhain
Subject Re: 15,000 tables
Date
Msg-id 1133462407.5734.43.camel@Andrea.peacock.de
Whole thread Raw
In response to Re: 15,000 tables  ("Gavin M. Roy" <gmr@ehpg.net>)
Responses Re: 15,000 tables  (Ron <rjpeace@earthlink.net>)
Re: 15,000 tables  ("Gavin M. Roy" <gmr@ehpg.net>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Rick Schumeyer"
Date:
Subject: COPY into table too slow with index
Next
From: Ron
Date:
Subject: Re: 15,000 tables