Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism - Mailing list pgsql-hackers

From Andres Freund
Subject Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism
Date
Msg-id 20160817232838.2ayollbnmf6qgytb@alap3.anarazel.de
Whole thread Raw
In response to Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism  (Peter Geoghegan <pg@heroku.com>)
Responses Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism  (Peter Geoghegan <pg@heroku.com>)
List pgsql-hackers
On 2016-08-17 16:23:29 -0700, Peter Geoghegan wrote:
> 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.

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



pgsql-hackers by date:

Previous
From: Ian Barwick
Date:
Subject: Re: psql: tab completion for \l
Next
From: Craig Ringer
Date:
Subject: Re: [GENERAL] C++ port of Postgres