Re: 15,000 tables

From: Michael Riess <mlriess(at)gmx(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: 15,000 tables
Date: 2005-12-01 14:51:37
Message-ID: dmn2lh$maj$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda 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!

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Michael Riess 2005-12-01 14:56:02 Re: 15,000 tables
Previous Message P@blo Villad@ 2005-12-01 14:30:29 Herramienta Graficadora Postgres

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Riess 2005-12-01 14:56:02 Re: 15,000 tables
Previous Message David Lang 2005-12-01 14:16:17 Re: 15,000 tables