Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism
Дата
Msg-id
20160817232838.2ayollbnmf6qgytb@alap3.anarazel.de
Ответ на
Список
Дерево обсуждения
CLUSTER, reform_and_rewrite_tuple(), and parallelism Peter Geoghegan <pg@heroku.com>
Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism Andres Freund <andres@anarazel.de>
Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism Peter Geoghegan <pg@heroku.com>
Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism Andres Freund <andres@anarazel.de>
Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism Peter Geoghegan <pg@heroku.com>
Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism Andres Freund <andres@anarazel.de>
Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism Alvaro Herrera <alvherre@2ndquadrant.com>
Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism Andres Freund <andres@anarazel.de>
Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism Peter Geoghegan <pg@heroku.com>
Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism Andres Freund <andres@anarazel.de>
Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism Amit Kapila <amit.kapila16@gmail.com>
Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism Peter Geoghegan <pg@heroku.com>
Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism Claudio Freire <klaussfreire@gmail.com>
On 2016-08-17 16:23:29 -0700, Peter Geoghegan wrote:
> On Wed, Aug 17, 2016 at 4:16 PM, Andres Freund  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.

Could you also provide a strace -ttt -T -c and a cpu cycles flamegraph?


В списке pgsql-hackers по дате отправления
От: Ian Barwick
Дата:
От: Craig Ringer
Дата:
FAQ