From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
---|---|
To: | "akp geek" <akpgeek(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Index question on postgres |
Date: | 2010-01-08 04:13:40 |
Message-ID: | D425483C2C5C9F49B5B7A41F89441547029626DF@postal.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If you do a:
VACUUM FULL ANALYZE
for both production and for test and then do an EXPLAIN on your queries,
what do the plans look like?
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of akp geek
Sent: Thursday, January 07, 2010 8:11 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Index question on postgres
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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2010-01-08 04:15:40 | Re: Index question on postgres |
Previous Message | akp geek | 2010-01-08 04:11:13 | Index question on postgres |