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 <dcor...@connx.com> wrote: > Post the results here > > > > *From:* akp geek [mailto:akpg...@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 <dcor...@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? > > > > *From:* pgsql-general-ow...@postgresql.org [mailto: > pgsql-general-ow...@postgresql.org] *On Behalf Of *akp geek > *Sent:* Thursday, January 07, 2010 8:11 PM > *To:* pgsql-general@postgresql.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 > > >
