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 bottleneck

[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 is the following: