| From: | Pedro Alves <pmalves(at)think(dot)pt> |
|---|---|
| To: | PostGreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Same conditions, different planning? |
| Date: | 2003-10-22 10:36:38 |
| Message-ID: | 20031022103638.GA27145@cosmos.inesc.pt |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)think(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-10-22 10:43:45 | Re: Same conditions, different planning? |
| Previous Message | Indra Heckenbach | 2003-10-22 10:22:16 | unexpected query behavior with UTF text |