Re: 15,000 tables
| От | Tom Lane |
|---|---|
| Тема | Re: 15,000 tables |
| Дата | |
| Msg-id | 11360.1133453022@sss.pgh.pa.us обсуждение |
| Ответ на | 15,000 tables (Michael Riess <mlriess@gmx.de>) |
| Ответы |
Re: 15,000 tables
Re: 15,000 tables Re: 15,000 tables |
| Список | 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 по дате отправления: