[GENERAL] data storage question

2001-09-05 Thread Evan Zane Macosko
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 ne

Re: [GENERAL] Problems with UPDATE

2001-08-20 Thread Evan Zane Macosko
? What primary keys or > indexes do these tables have? > > Andrew > > --- Evan Zane Macosko <[EMAIL PROTECTED]> wrote: > > Hello everyone, > > > > > > I am having a strange problem using the UPDATE > > function in Postgresql. I > >

[GENERAL] multiple table indexes

2001-08-20 Thread Evan Zane Macosko
Does Postgres support multiple table indexes? I want to update one table with data from another, but it's very slow because I have a rather bulky WHERE clause. I was wondering if I could index the two tables together to make execution faster. ---(end of broadcast)