Skip site navigation (1) Skip section navigation (2)

DB Design

From: "Michael Ryan S(dot) Puncia" <mpuncia(at)census(dot)gov(dot)ph>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: DB Design
Date: 2004-05-19 07:37:06
Message-ID: 200405190724.i4J7NuPW030497@mail.census.gov.ph (view raw or flat)
Thread:
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 ..

 

 

Responses

pgsql-performance by date

Next:From: Andrew McMillanDate: 2004-05-19 11:21:22
Subject: Re: DB Design
Previous:From: share-postgresDate: 2004-05-19 07:32:39
Subject: Re: filesystem option tuning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group