From: | Evan Zane Macosko <macosko(at)fas(dot)harvard(dot)edu> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | data storage question |
Date: | 2001-09-05 16:02:59 |
Message-ID: | Pine.OSF.4.33.0109051156330.17242-100000@is07.fas.harvard.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi everyone,
I would like to take advantage of postgresql's ability to store arrays
within records, but I wanted to make sure that I store them in the most
efficient way so my performance is optimized. I want to store
one-dimensional arrays of float values, each with about 6000 elements. I
need to store about 6 of these in each row of the table--the table will
eventually have about 10,000 rows. Will using the float8[] data type be
fast, or should i create my own data type (I was thinking of packing the
array in perl, maybe).
Also, in using the float8[] data type, I have another question: how do i
take a column of an existing postgresql table, and place it in a record of
a new table with the data type float8[]? All of the examples involving
arrays in the documentation only show INSERT VALUES statements, and thus
I'm not sure of the syntax if I want to use select instead of values.
thanks!
Evan
From | Date | Subject | |
---|---|---|---|
Next Message | miguel angel rojas aquino | 2001-09-05 16:08:29 | jdbc driver with BigDecimal patch |
Previous Message | Mihai Gheorghiu | 2001-09-05 15:57:48 | CREATE USER vs. createuser |