Re: [PERFORM] Very slow query (3-4mn) on a table with 25millions rows

2016-07-25 Thread Tom Lane
Abadie Lana writes: > I'm having a problem with a slow query - I tried several things to optimize > the queries but didn't really help. The output of explain analyse shows > sequential scan on a table of 25 million rows. Even though it is indexed and > (I put a multi-column index on the fields

[PERFORM] Very slow query (3-4mn) on a table with 25millions rows

2016-07-25 Thread Abadie Lana
Hi all I'm having a problem with a slow query - I tried several things to optimize the queries but didn't really help. The output of explain analyse shows sequential scan on a table of 25 million rows. Even though it is indexed and (I put a multi-column index on the fields used in the query), th