Re: Same conditions, different planning?

Pedro Alves wrote:
>    I'm having serious problems with a mission critical app that runs on
> postgres (and has been running for the past 3 years). It's rather large,
> and lately things are not going well. The planner is getting 'nuts',
> choosing ways that never end and completly stops the database.
>     The strange thing is that running the same query with the same database
> with the same conditions in other machine the planner works as expecter and
> all goes well.

Can we see explain analyze for the queries, relevant schema and other details?

And what version of postgresql is this? On what platform?

  Shridhar