Re: 15,000 tables

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: "Gavin M(dot) Roy" <gmr(at)ehpg(dot)net>
Cc: Michael Riess <mlriess(at)gmx(dot)de>, pgsql-performance(at)postgresql(dot)org
Subject: Re: 15,000 tables
Date: 2005-12-01 18:40:07
Message-ID: 1133462407.5734.43.camel@Andrea.peacock.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda pgsql-performance

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

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Edwin Quijada 2005-12-01 18:45:43 Re: consulta
Previous Message Gavin M. Roy 2005-12-01 18:07:44 Re: 15,000 tables

Browse pgsql-performance by date

  From Date Subject
Next Message Ron 2005-12-01 18:48:11 Re: 15,000 tables
Previous Message Gavin M. Roy 2005-12-01 18:07:44 Re: 15,000 tables