Re: Same conditions, different planning? - Mailing list pgsql-general

From Pedro Alves
Subject Re: Same conditions, different planning?
Date
Msg-id 20031022130557.GA1014@cosmos.inesc.pt
Whole thread Raw
In response to Re: Same conditions, different planning?  (Doug McNaught <doug@mcnaught.org>)
List pgsql-general
    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@think.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@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

pgsql-general by date:

Previous
From: Andrew Overholt
Date:
Subject: ...
Next
From: Andrew Overholt
Date:
Subject: Re: [PORTS] Redhat RPMs