the explain from both enviroments ??? need to be posted.
just one quick question. Why would the index I have created not being used?
Regards
On Thu, Jan 7, 2010 at 11:34 PM, Dann Corbit <DCorbit@connx.com> wrote:
Post the results here
From: akp geek [mailto:akpgeek@gmail.com] Sent: Thursday, January 07, 2010 8:30 PM To: Dann Corbit Cc:pgsql-general@postgresql.org Subject: Re: [GENERAL] Index question on postgres
I did that and the Explain look different
Regards
On Thu, Jan 7, 2010 at 11:13 PM, Dann Corbit <DCorbit@connx.com> wrote:
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?
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?
