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

From Gavin M. Roy
Subject Re: 15,000 tables
Date
Msg-id 81A7970E-20C0-441A-9F21-4FC6D8759BF2@ehpg.net
Whole thread Raw
In response to Re: 15,000 tables  (Tino Wildenhain <tino@wildenhain.de>)
Responses Re: 15,000 tables  ("Gavin M. Roy" <gmr@ehpg.net>)
List pgsql-performance
Here's a fairly recent post on reiserfs (and performance):

http://archives.postgresql.org/pgsql-novice/2005-09/msg00007.php

I'm still digging on performance of ext2 vrs journaled filesystems,
as I know I've seen it before.

Gavin


My point was not in doing an fsck, but rather in
On Dec 1, 2005, at 10:40 AM, 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
>

Gavin M. Roy
800 Pound Gorilla
gmr@ehpg.net



pgsql-performance by date:

Previous
From: Ron
Date:
Subject: Re: 15,000 tables
Next
From: Tom Lane
Date:
Subject: Re: 15,000 tables