Re: Index question on postgres

[akp geek <akpgeek@xxxxxxxxx>]

The volume of data is less in Test compared to prod. and I synced the postgresql.conf file in both environments

Regards

On Fri, Jan 8, 2010 at 1:55 PM, Vick Khera <vivek@xxxxxxxxx> wrote:

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?