От: Kevin Grittner
Тема: Re: Optimization idea
Дата: ,
Msg-id: 4BD15D1D0200002500030D37@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Re: Optimization idea  (Cédric Villemain)
Список: pgsql-performance

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

Optimization idea  (Vlad Arkhipov, )
 Re: Optimization idea  (Greg Smith, )
  Re: Optimization idea  (Vlad Arkhipov, )
   Re: Optimization idea  (Robert Haas, )
    Re: Optimization idea  (Cédric Villemain, )
     Re: Optimization idea  (Robert Haas, )
      Re: Optimization idea  (Cédric Villemain, )
       Re: Optimization idea  (Robert Haas, )
        Re: Optimization idea  (Tom Lane, )
         Re: Optimization idea  (Robert Haas, )
     Re: Optimization idea  ("Kevin Grittner", )
    Re: Optimization idea  (Vlad Arkhipov, )
     Re: Optimization idea  (Cédric Villemain, )
      Re: Optimization idea  (Robert Haas, )
       Re: Optimization idea  (Cédric Villemain, )
        Re: Optimization idea  (Vlad Arkhipov, )
       Re: Optimization idea  (Cédric Villemain, )
        Re: Optimization idea  (Cédric Villemain, )
  Re: Optimization idea  (Vlad Arkhipov, )
 Re: Optimization idea  (Robert Haas, )
  Re: Optimization idea  (Cédric Villemain, )

Cédric Villemain<> wrote:
> 2010/4/23 Robert Haas <>:

>> Since all your data is probably fully cached, at a first cut, I
>> might try setting random_page_cost and seq_page_cost to 0.005 or
>> so, and adjusting effective_cache_size to something appropriate.
>
> that will help worrect the situation, but the planner is loosing
> here I think.

The planner produces a lot of possible plans to produce the
requested results, and then calculates a cost for each.  The lowest
cost plan which will produce the correct results is the one chosen.
If your costing factors don't represent the reality of your
environment, it won't pick the best plan for your environment.

-Kevin


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

От: Cédric Villemain
Дата:
Сообщение: Re: Optimization idea
От: Eliot Gable
Дата:
Сообщение: Re: Replacing Cursors with Temporary Tables