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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew McMillan 2004-05-19 11:21:22 Re: DB Design
Previous Message share-postgres 2004-05-19 07:32:39 Re: filesystem option tuning