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

From: Sam Mason
Subject: Re: [HACKERS] Planner doesn't look at LIMIT?
Date: ,
Msg-id: 20050723104235.GM62747@colo.samason.me.uk
(view: Whole thread, Raw)
In response to: Re: [HACKERS] Planner doesn't look at LIMIT?  (Tom Lane)
List: pgsql-performance

Tree view

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 by date:

From: Sam Mason
Date:
Subject: Re: [HACKERS] Planner doesn't look at LIMIT?
From: John Mendenhall
Date:
Subject: re: performance decrease after reboot