Re: Planner doesn't look at LIMIT?

От: Sam Mason
Тема: Re: Planner doesn't look at LIMIT?
Дата: ,
Msg-id: 20050722145122.GL62747@colo.samason.me.uk
(см: обсуждение, исходный текст)
Ответ на: Planner doesn't look at LIMIT?  (Dawid Kuroczko)
Список: 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, )

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 по дате сообщения:

От: Dawid Kuroczko
Дата:
Сообщение: Re: Planner doesn't look at LIMIT?
От: Sam Mason
Дата:
Сообщение: Re: [HACKERS] Planner doesn't look at LIMIT?