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 <pg@heroku.com>)
Ответы Re: CLUSTER, reform_and_rewrite_tuple(), and parallelism  (Peter Geoghegan <pg@heroku.com>)
Список 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 по дате отправления:

Предыдущее
От: Ian Barwick
Дата:
Сообщение: Re: psql: tab completion for \l
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: [GENERAL] C++ port of Postgres