On 12/1/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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
>
Maybe he is using some kind of weird ERP... take the case of BaaN
(sadly i use it in my work): BaaN creates about 1200 tables per
company and i have no control of it... we have about 12000 tables
right now...
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)