data storage question

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

Browse pgsql-general by date

  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