Postgres Pro
Downloads
Home   >   mailing lists

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

From Doug McNaught
Subject Re: Same conditions, different planning?
Date
Msg-id m3y8vdsb45.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Same conditions, different planning?  (Pedro Alves <pmalves@think.pt>)
Responses Re: Same conditions, different planning?  (Pedro Alves <pmalves@think.pt>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Pedro Alves
Date:
Subject: Re: Same conditions, different planning?
Next
From: Peter Childs
Date:
Subject: Trigger