Same conditions, different planning?

    Hi


   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.


    All is vaccumed analyzed.


    What can cause this?


    Tkx




--
Pedro Miguel G. Alves            pmalves@think.pt
THINK - Tecnologias de Informação    www.think.pt
Tel:   +351 21 413 46 00  Av. José Gomes Ferreira
Fax:   +351 21 413 46 09     nº 13 1495-139 ALGÉS