Re: Very ineffective plan with merge join - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Very ineffective plan with merge join
Date
Msg-id 4BC73FF00200002500030989@gw.wicourts.gov
Whole thread Raw
In response to Re: Very ineffective plan with merge join  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Very ineffective plan with merge join  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Very ineffective plan with merge join  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I'm not sure how much it would help to increase the statistics
> targets, but that would be worth trying.
I notice that the scan rowcount estimates are very accurate, there's
that one hash join result that's way off, though.
What's up with the sort of _accrged7200 (in the slower plan) taking
in 3.5 million rows and putting out 1 row?  There's something there
I'm not understanding.
-Kevin


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Rogue TODO list created
Next
From: Tom Lane
Date:
Subject: Re: Very ineffective plan with merge join