Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism
Дата
Msg-id CAM3SWZSuHVBywAxMS7o3hHCu-fPFQ=6t6Nf4M0nwc-Xeksp-Og@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism  (Andres Freund <andres@anarazel.de>)
Ответы Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On Wed, Aug 17, 2016 at 4:16 PM, Andres Freund <andres@anarazel.de> wrote:
>> Does anyone have any ideas on how to:
>>
>> 1). Directly address the reform_and_rewrite_tuple() bottleneck.
>
> What part of is actually the expensive bit? It does a whole lot of
> things. Forming/Deforming tuples, the hash lookups in
> rewrite_heap_tuple(), ...?

Perhaps the attached svg "flamegraph" will give you some idea. This is
based on the "perf cache-misses" event type.

--
Peter Geoghegan

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism
Следующее
От: Ian Barwick
Дата:
Сообщение: Re: psql: tab completion for \l