Re: 15,000 tables

From: Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de>
To: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 15,000 tables
Date: 2005-12-01 16:30:48
Message-ID: 7F8F91D4-9A18-4741-A485-9B5208FB3180@pharmaline.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda pgsql-performance

On 01.12.2005, at 17:04 Uhr, Michael Riess wrote:

> No. Our database contains tables for we content management systems.
> The server hosts approx. 500 cms applications, and each of them has
> approx. 30 tables.

Just for my curiosity: Are the "about 30 tables" with similar schemas
or do they differ much?

We have a small CMS system running here, where I have all information
for all clients in tables with relationships to a client table.

But I assume you are running a pre-build CMS which is not designed
for "multi-client ability", right?

cug

--
PharmaLine, Essen, GERMANY
Software and Database Development

In response to

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Esteban Gutierrez 2005-12-01 16:32:09 Ayuda con FK
Previous Message Christian Bustos 2005-12-01 16:29:43 Re: alter de una tabla

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-12-01 16:34:46 Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Previous Message Markus Wollny 2005-12-01 16:30:42 Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0