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

2010-01-05 Thread Gauthier, Dave
I actually tackled a problem very much like this in the distant past with a different DB. I think one of the practical questions you have to ask is whether or not you really need all that detailed data, or would storing summarized data serve. If (for example) the components are fabricated on w

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