Re: schema design question - Mailing list pgsql-performance

From Adam Tauno Williams
Subject Re: schema design question
Date
Msg-id 1187569327.4568.5.camel@aleph.wmmi.net
Whole thread Raw
In response to Re: schema design question  ("mark overmeer" <markovermeer@gmail.com>)
List pgsql-performance

> However, it still doesn't answer my question about the EV model (where
> each attribute is given its own table).

Do a TABLE(object_id INT, attribute STRING, value STRING) if you just
want to be able to search for objects by an attribute.  But better yet
look at one of the thousand object persistence systems out there,  not
much to be gained from re-inventing the wheel.

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


pgsql-performance by date:

Previous
From: "Leon Mergen"
Date:
Subject: Re: [pgsql-jobs] Looking for database hosting
Next
From: "Andrew Hammond"
Date:
Subject: Re: [pgsql-jobs] Looking for database hosting