Re: [ADMIN] Query with limit takes hours

2012-10-14 Thread Vincent
On 10/14/2012 08:56 AM, henk de wit wrote: On PG 9.1 and 9.2 I'm running the following query: SELECT * FROM stream_store JOIN ( SELECT UNNEST(stream_store_ids) AS id FROM stream_store_version_index WHERE stream_id = 607106 A

[ADMIN] Query with limit takes hours

2012-10-13 Thread henk de wit
On PG 9.1 and 9.2 I'm running the following query: SELECT *FROM stream_store JOIN(SELECT UNNEST(stream_store_ids) AS idFROM stream_store_version_index WHERE stream_id = 607106 AND version = 11) AS records USI