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

From Tom Lane
Subject Re: 15,000 tables
Date
Msg-id 11360.1133453022@sss.pgh.pa.us
Whole thread Raw
In response to 15,000 tables  (Michael Riess <mlriess@gmx.de>)
Responses Re: 15,000 tables
Re: 15,000 tables
Re: 15,000 tables
List pgsql-performance
Michael Riess <mlriess@gmx.de> writes:
> (We NEED that many tables, please don't recommend to reduce them)

No, you don't.  Add an additional key column to fold together different
tables of the same structure.  This will be much more efficient than
managing that key at the filesystem level, which is what you're
effectively doing now.

(If you really have 15000 distinct rowtypes, I'd like to know what
your database design is...)

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: slow insert into very large table
Next
From: Jaime Casanova
Date:
Subject: Re: 15,000 tables