Question concerning arrays
От | Christian Rengstl |
---|---|
Тема | Question concerning arrays |
Дата | |
Msg-id | 44A135F9.0AD0.0080.0@klinik.uni-regensburg.de обсуждение исходный текст |
Ответы |
Re: Question concerning arrays
Re: Question concerning arrays Re: Question concerning arrays |
Список | 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 personswhose values (integer) have to be entered in the db, but per person the amount of values ranges from 10 to around50. Now my question is if it makes sense, concerning performance, to store these integer values in arrays or if itis better to change the design so that the values are stored separately in fields in tables. I have to add, that it isnot 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
В списке pgsql-general по дате отправления: