Re: How many tables is too many tables?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "cydatamatt(at)gmail(dot)com" <cydatamatt(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How many tables is too many tables?
Date: 2005-09-20 03:21:23
Message-ID: 1832.1127186483@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"cydatamatt(at)gmail(dot)com" <cydatamatt(at)gmail(dot)com> writes:
> We currently have around 400,000 tables
> and I would estimate that the vast majority of these tables are
> relatively small (less than 200 rows).

Stop right there, and go redesign your schema. This is unbelievably
wrong :-(

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message John A Meinel 2005-09-20 04:22:20 Re: How many tables is too many tables?
Previous Message Tom Lane 2005-09-20 03:05:41 Re: Index Selection: ORDER BY vs. PRIMARY KEY