| From: | Vernon Wu <vernonw(at)gatewaytech(dot)com> | 
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> | 
| Subject: | Using inheritance - a table design question | 
| Date: | 2002-04-01 01:22:57 | 
| Message-ID: | DHCMOA9WU615Z98LGLJUQSRSN5YG.3ca7b671@kimiko | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Hi,
I am working on DB table design for an application. In the application, the account 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 or not.
Thanks,
Vernon
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fran Fabrizio | 2002-04-01 15:31:54 | Re: Recursion in plpgsql | 
| Previous Message | Randall Perry | 2002-03-31 22:43:56 | Re: Converting comma-delimited data to tab-delimited |