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 >
