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

From Guido Neitzer
Subject Re: 15,000 tables
Date
Msg-id 7F8F91D4-9A18-4741-A485-9B5208FB3180@pharmaline.de
Whole thread Raw
In response to Re: 15,000 tables  (Michael Riess <mlriess@gmx.de>)
List 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



Attachment

pgsql-performance by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Next
From: Tom Lane
Date:
Subject: Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0