Horton

DB Design

Michael Ryan S. Puncia <mpuncia@census.gov.ph>

View thread
From: "Michael Ryan S. Puncia" <mpuncia@census.gov.ph>
To: <pgsql-performance@postgresql.org>
Date: 2004-05-19T07:37:06Z
Lists: pgsql-performance 
Hi Guys,

   

      My question is .. which is better design

 

1.	Single Table with 50 million records or
2.	Multiple Table using inheritance to the parents table

 

 

I will use this only for query purpose ..

 

Thanks ..