Re: [GENERAL] Query that does not use indexes

2007-03-28 Thread Ragnar
On þri, 2007-03-27 at 12:54 +0200, Denis Gasparin wrote: I have a query that performs a multiple join between four tables and that doesn't use the defined indexes. If I set enable_seqscan to off, the query obviously uses the indexes and it is considerable faster than normal planned execution

[GENERAL] Query that does not use indexes

2007-03-27 Thread Denis Gasparin
I have a query that performs a multiple join between four tables and that doesn't use the defined indexes. If I set enable_seqscan to off, the query obviously uses the indexes and it is considerable faster than normal planned execution with enable_seqscan=true. Can you give me a reason why