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

From Michael Riess
Subject Re: 15,000 tables
Date
Msg-id dmn2lh$maj$1@news.hub.org
Whole thread Raw
In response to Re: 15,000 tables  (David Lang <dlang@invendra.net>)
Responses Re: 15,000 tables
List pgsql-performance
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!

pgsql-performance by date:

Previous
From: David Lang
Date:
Subject: filesystem performance with lots of files
Next
From: David Lang
Date:
Subject: Re: About the relation between fragmentation of file and