Re: schema design question - Mailing list pgsql-performance

From mark overmeer
Subject Re: schema design question
Date
Msg-id ea41f7570708190823m5b63fc85jfe57c2d3b5d4d842@mail.gmail.com
Whole thread Raw
In response to Re: schema design question  (Adam Tauno Williams <adamtaunowilliams@gmail.com>)
List pgsql-performance
Hi Adam,

Thanks for the fast reply. What should inherit from what? Class A (e.g. 'todo item') is certainly not derived from property X (e.g. 'startdate'). Class A version 2 has different properties (some are removed, others are added). Can you elaborate / say I'm wrong / give an example ? Thanks,

Mark


2007/8/19, Adam Tauno Williams <adamtaunowilliams@gmail.com>:

> Maybe not completely the wright place to ask but... I have this schema
> design question (db is postgres of course). I have a couple of classes
> with attributes. The only goal is to search the object that I want to
> find (which is stored on the harddrive).
> I have hundreds of classes that are similar but not the same. They all
> have attributes/properties (type is probably String), e.g. (in pseudo
> code):

Use table inheritance.

--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

pgsql-performance by date:

Previous
From: Adam Tauno Williams
Date:
Subject: Re: schema design question
Next
From: David Fetter
Date:
Subject: Re: schema design question