Re: 15,000 tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Riess <mlriess(at)gmx(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 15,000 tables
Date: 2005-12-01 16:03:42
Message-ID: 11360.1133453022@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda pgsql-performance

Michael Riess <mlriess(at)gmx(dot)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

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Michael Riess 2005-12-01 16:04:06 Re: 15,000 tables
Previous Message Edwin Quijada 2005-12-01 15:55:34 Re: Particionamiento de tablas

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Riess 2005-12-01 16:04:06 Re: 15,000 tables
Previous Message Tom Lane 2005-12-01 15:50:14 Re: slow insert into very large table