Re: Very ineffective plan with merge join

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Very ineffective plan with merge join
Дата
Msg-id 4BC73FF00200002500030989@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Very ineffective plan with merge join  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Very ineffective plan with merge join
Re: Very ineffective plan with merge join
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Rogue TODO list created
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Very ineffective plan with merge join