Re: Same conditions, different planning?

Hum... no, I didn't :/ I thought vacuum analyze would be enough. Next
time (neve, I hope) I will have that in mind

On Wed, Oct 22, 2003 at 08:36:10AM -0400, Doug McNaught wrote:
> Pedro Alves <pmalves(at)think(dot)pt> writes:
>
> > As a final attempt I tryed a pg_dumpall; initdb; psql -f <file> . It
> > seems to work as expected.... (!)
>
> It may have been a case of index bloat--did you ever REINDEX? That
> might have fixed it without a dump/reload.
>
> 7.4 has fixes for the index bloat problem.
>
> -Doug
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

--
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