Re: Same conditions, different planning?

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Pedro Alves <pmalves(at)think(dot)pt>
Cc: Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>, PostGreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Same conditions, different planning?
Date: 2003-10-22 12:36:10
Message-ID: m3y8vdsb45.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Childs 2003-10-22 13:01:16 Trigger
Previous Message Pedro Alves 2003-10-22 12:26:23 Re: Same conditions, different planning?