On Thu, Jan 7, 2010 at 11:11 PM, akp geek <akpgeek@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
