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

From Gavin M. Roy
Subject Re: 15,000 tables
Date
Msg-id 9A858930-1CA6-4238-92D4-D1E945683653@ehpg.net
Whole thread Raw
In response to Re: 15,000 tables  (Michael Riess <mlriess@gmx.de>)
Responses Re: 15,000 tables  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-performance
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.

Gavin

On Dec 1, 2005, at 6:51 AM, Michael Riess wrote:

> Hi David,
>
>> with 15,000 tables you are talking about a LOT of files to hold
>> these (30,000 files with one index each and each database being
>> small enough to not need more then one file to hold it), on linux
>> ext2/3 this many files in one directory will slow you down horribly.
>
> We use ReiserFS, and I don't think that this is causing the
> problem ... although it would probably help to split the directory
> up using tablespaces.
>
> But thanks for the suggestion!
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

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



pgsql-performance by date:

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