Re: Planner doesn't look at LIMIT? - Mailing list pgsql-performance

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

Previous
From: Madison Kelly
Date:
Subject: Another index question
Next
From: Madison Kelly
Date:
Subject: Solved (was: Re: Another index question)