Re: 15,000 tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Gavin M. Roy" <gmr@xxxxxxxx>
Subject: Re: 15,000 tables
From: Tino Wildenhain <tino@xxxxxxxxxxxxx>
Date: Thu, 01 Dec 2005 19:40:07 +0100
Cc: Michael Riess <mlriess@xxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <9A858930-1CA6-4238-92D4-D1E945683653@xxxxxxxx>
References: <dmmujf$2rgd$1@xxxxxxxxxxxx> <Pine.LNX.4.62.0512010609060.2807@xxxxxxxxxxxxx> <dmn2lh$maj$1@xxxxxxxxxxxx> <9A858930-1CA6-4238-92D4-D1E945683653@xxxxxxxx>

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

Follow-Ups:
- Re: 15,000 tables
  - From: Gavin M. Roy
- Re: 15,000 tables
  - From: Ron

References:
- 15,000 tables
  - From: Michael Riess
- Re: 15,000 tables
  - From: David Lang
- Re: 15,000 tables
  - From: Michael Riess
- Re: 15,000 tables
  - From: Gavin M. Roy

Prev by Date: COPY into table too slow with index
Next by Date: Re: 15,000 tables
Previous by thread: Re: 15,000 tables
Next by thread: Re: 15,000 tables
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux