15,000 tables

From: Michael Riess <mlriess(at)gmx(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: 15,000 tables
Date: 2005-12-01 13:42:14
Message-ID: dmmujf$2rgd$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda pgsql-performance

Hi,

we are currently running a postgres server (upgraded to 8.1) which has
one large database with approx. 15,000 tables. Unfortunately performance
suffers from that, because the internal tables (especially that which
holds the attribute info) get too large.

(We NEED that many tables, please don't recommend to reduce them)

Logically these tables could be grouped into 500 databases. My question is:

Would performance be better if I had 500 databases (on one postgres
server instance) which each contain 30 tables, or is it better to have
one large database with 15,000 tables? In the old days of postgres 6.5
we tried that, but performance was horrible with many databases ...

BTW: I searched the mailing list, but found nothing on the subject - and
there also isn't any information in the documentation about the effects
of the number of databases, tables or attributes on the performance.

Now, what do you say? Thanks in advance for any comment!

Mike

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message David Lang 2005-12-01 14:16:17 Re: 15,000 tables
Previous Message Alvaro Herrera 2005-12-01 13:33:59 Re: Relación pg_class y pg_attribute

Browse pgsql-performance by date

  From Date Subject
Next Message Andreas Pflug 2005-12-01 14:00:07 Re: slow insert into very large table
Previous Message Bill McGonigle 2005-12-01 12:44:22 Re: About the relation between fragmentation of file and VACUUM