Postgres Pro
Downloads
Home   >   mailing lists

Re: Planner ignoring to use INDEX SCAN - Mailing list pgsql-general

From Richard Huxton
Subject Re: Planner ignoring to use INDEX SCAN
Date
Msg-id 47625C29.8090700@archonet.com
Whole thread Raw
In response to Planner ignoring to use INDEX SCAN  (Ashish Karalkar <ashish_postgre@yahoo.co.in>)
Responses Re: Planner ignoring to use INDEX SCAN
List pgsql-general
Tree view 
Ashish Karalkar wrote:
> query which was taking seconds on the join of these two table
> suddenly started taking 20/25 min

Show the EXPLAIN ANALYSE of your problem query and someone will be able
to tell you why.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Ashish Karalkar
Date:
Subject: Planner ignoring to use INDEX SCAN
Next
From: André Volpato
Date:
Subject: Re: Hash join in 8.3