Postgres Pro
Downloads
Home   >   mailing lists

DB Design - Mailing list pgsql-performance

From Michael Ryan S. Puncia
Subject DB Design
Date
Msg-id 200405190724.i4J7NuPW030497@mail.census.gov.ph
Whole thread Raw
Responses Re: DB Design  (Andrew McMillan <andrew@catalyst.net.nz>)
Re: DB Design  (Mark Kirkwood <markir@paradise.net.nz>)
List pgsql-performance
Tree view

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 ..

 

 

pgsql-performance by date:

Previous
From: Marty Scholes
Date:
Subject: Re: Quad processor options
Next
From: Andrew McMillan
Date:
Subject: Re: DB Design