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
