Use Inherrtance or not, a table desing question

From: Vernon Wu <vernonw(at)gatewaytech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Use Inherrtance or not, a table desing question
Date: 2002-03-31 21:36:47
Message-ID: SQA0KF4W3XTNIHEAMJFXW07E0WS8241.3ca7816f@kimiko
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

I am working on DB table design for an application. In the application, the search is based on sex: male or female. To
have a better performance, I am thinking about to have two profile tables for each sex. Since the most of data fields of
the two tables are identical, for the design point of view, it is better to use the inheritance, that will have three tables:
person table and two its children tables: male and female. I am very new to Postgres and don't know any its internal
structure. Please enlighten me whether I shall use the inheritance for a large size of data.

Thanks,

Vernon

Browse pgsql-general by date

  From Date Subject
Next Message Randall Perry 2002-03-31 22:43:56 Re: Converting comma-delimited data to tab-delimited
Previous Message Randall Perry 2002-03-31 21:25:12 Re: Converting comma-delimited data to tab-delimited