On 12/1/05, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Michael Riess <mlriess@xxxxxx> 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 ;)
