Re: [HACKERS] Planner doesn't look at LIMIT?

От: Sam Mason
Тема: Re: [HACKERS] Planner doesn't look at LIMIT?
Дата: ,
Msg-id: 20050723104235.GM62747@colo.samason.me.uk
(см: обсуждение, исходный текст)
Ответ на: Re: [HACKERS] Planner doesn't look at LIMIT?  (Tom Lane)
Список: pgsql-performance

Скрыть дерево обсуждения

Planner doesn't look at LIMIT?  (Dawid Kuroczko, )
 Re: Planner doesn't look at LIMIT?  (PFC, )
 Re: Planner doesn't look at LIMIT?  (Tom Lane, )
  Re: Planner doesn't look at LIMIT?  (Dawid Kuroczko, )
  Re: Planner doesn't look at LIMIT?  (Tom Lane, )
   Re: [HACKERS] Planner doesn't look at LIMIT?  (Simon Riggs, )
    Re: [HACKERS] Planner doesn't look at LIMIT?  (Tom Lane, )
     Re: [HACKERS] Planner doesn't look at LIMIT?  (Sam Mason, )
   Re: Planner doesn't look at LIMIT?  (Dawid Kuroczko, )
   Re: Planner doesn't look at LIMIT?  (Ian Westmacott, )
    Re: Planner doesn't look at LIMIT?  (Tom Lane, )
     Re: Planner doesn't look at LIMIT?  (Ian Westmacott, )
 Re: Planner doesn't look at LIMIT?  (Sam Mason, )

Tom Lane wrote:
>Could be.  I went back to look at Sam Mason's report about three weeks
>ago, and it definitely seems to explain his issue.

I've just built a patched version as well and it appears to be doing
what I think is the right thing now.  I.e. actually picking the
plan with the lower cost.

Thanks!


  Sam


В списке pgsql-performance по дате сообщения:

От: Sam Mason
Дата:
Сообщение: Re: [HACKERS] Planner doesn't look at LIMIT?
От: John Mendenhall
Дата:
Сообщение: re: performance decrease after reboot