Re: add_path optimization - Mailing list pgsql-hackers

From Tom Lane
Subject Re: add_path optimization
Date
Msg-id 29382.1233683247@sss.pgh.pa.us
Whole thread Raw
In response to Re: add_path optimization  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: add_path optimization  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> It's now been an hour and 30 minutes; so, while 8.4 does a much better
> job of estimating how many rows will be returned, the plan it
> generates is much slower for this query.

Can you let it run to completion?  Without explain analyze results
it's going to be pretty difficult to isolate the problem.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: add_path optimization
Next
From: "Kevin Grittner"
Date:
Subject: Re: add_path optimization