Re: [PERFORM] Querying with multicolumn index

От: Tom Lane
Тема: Re: [PERFORM] Querying with multicolumn index
Дата: ,
Msg-id: 14684.1481417363@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: [PERFORM] Querying with multicolumn index  (Eric Jiang)
Ответы: Re: [PERFORM] Querying with multicolumn index  (Eric Jiang)
Список: pgsql-performance

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

[PERFORM] Querying with multicolumn index  (Eric Jiang, )
 Re: [PERFORM] Querying with multicolumn index  (Andreas Joseph Krogh, )
  Re: [PERFORM] Querying with multicolumn index  (Eric Jiang, )
 Re: [PERFORM] Querying with multicolumn index  (Tom Lane, )
  Re: [PERFORM] Querying with multicolumn index  (Tomas Vondra, )
   Re: [PERFORM] Querying with multicolumn index  (Tom Lane, )
   Re: [PERFORM] Querying with multicolumn index  (Daniel Blanch Bataller, )
    Re: [PERFORM] Querying with multicolumn index  (Daniel Blanch Bataller, )
 Re: [PERFORM] Querying with multicolumn index  (Daniel Blanch Bataller, )
  Re: [PERFORM] Querying with multicolumn index  (Eric Jiang, )
   Re: [PERFORM] Querying with multicolumn index  (Tom Lane, )
    Re: [PERFORM] Querying with multicolumn index  (Eric Jiang, )

Eric Jiang <> writes:
> We aren't using any special planner settings - all enable_* options are "on".

No, I'm asking about the cost settings (random_page_cost etc).  The cost
estimates you're showing seem impossible with the default settings.

            regards, tom lane



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

От: Daniel Blanch Bataller
Дата:
Сообщение: Re: [PERFORM] Querying with multicolumn index
От: ProPAAS DBA
Дата:
Сообщение: [PERFORM] Isolation of tx logs on VMware