Re: [PERFORM] Big array speed issues

2006-06-21 Thread Merkel Marcel (CR/AEM4)
Von: Merlin Moncure [mailto:[EMAIL PROTECTED] An: Merkel Marcel (CR/AEM4) Cc: pgsql-performance@postgresql.org Betreff: Re: [PERFORM] Big array speed issues On 6/20/06, Merkel Marcel (CR/AEM4) <[EMAIL PROTECTED]> wrote: > I use libpqxx to access the database. This might be another b

[PERFORM] Big array speed issues

2006-06-20 Thread Merkel Marcel (CR/AEM4)
Title: Big array speed issues Hi, I have some speed issues with a big array in a table. I hope you can help me to tune my query. My table looks like this: Id    |  timestamp  | map Primary key |  timestamp  | array of real [34][28] With an index on timestamp My query