From: | "Christian Rengstl" <Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Question concerning arrays |
Date: | 2006-06-27 11:43:21 |
Message-ID: | 44A135F9.0AD0.0080.0@klinik.uni-regensburg.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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=...
Thanks
Chris
--
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230
From | Date | Subject | |
---|---|---|---|
Next Message | surabhi.ahuja | 2006-06-27 12:22:19 | planning to upgrade to 8.1 |
Previous Message | Oleg Bartunov | 2006-06-27 11:31:09 | Re: TSearch vs. Homebrew |