Re: 15,000 tables

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