Postgres Pro
Downloads
Home   >   mailing lists

Re: How many tables is too many tables? - Mailing list pgsql-performance

From Tom Lane
Subject Re: How many tables is too many tables?
Date
Msg-id 1832.1127186483@sss.pgh.pa.us
Whole thread Raw
In response to How many tables is too many tables?  ("cydatamatt@gmail.com" <cydatamatt@gmail.com>)
List pgsql-performance
Tree view 
"cydatamatt@gmail.com" <cydatamatt@gmail.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index Selection: ORDER BY vs. PRIMARY KEY
Next
From: John A Meinel
Date:
Subject: Re: How many tables is too many tables?