Index question on postgres

From: akp geek <akpgeek(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Index question on postgres
Date: 2010-01-08 04:11:13
Message-ID: 2024a9fb1001072011k6843b32bmcd49ddc6d3814844@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All -

I have query in production and test. The tables in both the
environment has the same structure ,indexes and constraints. But the in the
test and the prod the explain plan is totally different. In test environment
the query is taking long time and noticed that indexes are not being
utilized ? I am not able to figure it Can you please share your thoughts?

Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2010-01-08 04:13:40 Re: Index question on postgres
Previous Message Scott Marlowe 2010-01-08 04:04:45 Re: conditional rule not applied