Re: Planner doesn't look at LIMIT?

From: Sam Mason
Subject: Re: Planner doesn't look at LIMIT?
Date: ,
Msg-id: 20050722145122.GL62747@colo.samason.me.uk
(view: Whole thread, Raw)
In response to: Planner doesn't look at LIMIT?  (Dawid Kuroczko)
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, )

Dawid Kuroczko wrote:
>work_mem = 102400

>...I tried tweaking cpu_*, work_mem, effective_cache and so on, but without
>any luck.

I'm hoping you didn't tweak it enough!  I posted something similar
this a while ago, but haven't since got around to figuring out
a useful test case to send to the list.

Try reducing your work_mem down to 1000 or so and things should
start doing what you expect.


  Sam


pgsql-performance by date:

From: Dawid Kuroczko
Date:
Subject: Re: Planner doesn't look at LIMIT?
From: Sam Mason
Date:
Subject: Re: [HACKERS] Planner doesn't look at LIMIT?