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
Ответ на
Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism (Peter Geoghegan)
Список
Дерево обсуждения
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 по дате отправления