On Tue, Jun 27, 2006 at 13:43:21 +0200,
Christian Rengstl <[EMAIL PROTECTED]> wrote:
> Hi list,
>
> i am in the middle of breaking my head over designing a database and came to
> the following question/problem: i have persons whose values (integer) have to
> be entered in the db, but per person the amount of values ranges from 10 to
> around 50. Now my question is if it makes sense, concerning performance, to
> store these integer values in arrays or if it is better to change the design
> so that the values are stored separately in fields in tables. I have to add,
> that it is not unlikely (or at least it won't happen very often) that select
> queries will try to find one of those specific values, but rather something
> like select * from persons where person_id=...
If the data isn't actually a vector, than it is probably better to not use
arrays. This will provide you with more flexibility.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
