Re: [GENERAL] Shall I use PostgreSQL Array Type in The Following Case

2010-01-05 Thread Gauthier, Dave
n the process. Something to think about ! -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Yan Cheng Cheok Sent: Monday, January 04, 2010 8:13 PM To: pgsql-general@postgresql.org Subject: [GENERAL] Shall I use PostgreSQL Arr

Re: [GENERAL] Shall I use PostgreSQL Array Type in The Following Case

2010-01-05 Thread Grzegorz Jaƛkiewicz
the array type is first and foremost the storage type. It can be managed to be used to add 3rd dimension of access to database, but that will always come with certain price. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.post

Re: [GENERAL] Shall I use PostgreSQL Array Type in The Following Case

2010-01-05 Thread Sam Mason
On Mon, Jan 04, 2010 at 05:12:56PM -0800, Yan Cheng Cheok wrote: > Measurement table will have 24 * 50 million rows in 1 day > Is it efficient to design that way? > > **I wish to have super fast write speed, and reasonable fast read speed from > the database.** When writing software there's (al

[GENERAL] Shall I use PostgreSQL Array Type in The Following Case

2010-01-04 Thread Yan Cheng Cheok
I realize there is Array data type for PostgreSQL. http://www.postgresql.org/docs/8.1/interactive/arrays.html Currently, I need to use database to store measurement result of a semiconductor factory. They are producing semicondutor units. Every semicondutor units can have variable number of me