On Thu, Jan 7, 2010 at 11:11 PM, akp geek <akpg...@gmail.com> wrote: > 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?
Is the same amount of data in both? Are the other configs of the server the same? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
