От: Merlin Moncure
Тема: Re: Finding bottleneck
Дата: ,
Msg-id: 6EE64EF3AB31D5448D0007DD34EEB3417DD026@Herge.rcsinc.local
(см: обсуждение, исходный текст)
Ответ на: Finding bottleneck  (Kari Lavikka)
Ответы: Re: Finding bottleneck  (Tom Lane)
Re: Finding bottleneck  (Kari Lavikka)
Список: pgsql-performance

Скрыть дерево обсуждения

Finding bottleneck  (Kari Lavikka, )
 Re: Finding bottleneck  (Gavin Sherry, )
 Re: Finding bottleneck  (Claus Guttesen, )
 Re: Finding bottleneck  ("Merlin Moncure", )
 Re: Finding bottleneck  ("Luke Lonergan", )
  Re: Finding bottleneck  (Kari Lavikka, )
   Re: Finding bottleneck  (Tom Lane, )
 Re: Finding bottleneck  ("Merlin Moncure", )
  Re: Finding bottleneck  (Tom Lane, )
  Re: Finding bottleneck  (Kari Lavikka, )
   Re: Finding bottleneck  (Tom Lane, )
    Re: Finding bottleneck  (Kari Lavikka, )
     Re: Finding bottleneck  (Tom Lane, )
    Re: Finding bottleneck  (Kari Lavikka, )
     Re: Finding bottleneck  (Tom Lane, )
 Re: Finding bottleneck  (Ron, )
 Re: Finding bottleneck  ("Merlin Moncure", )
  Re: Finding bottleneck  (Tom Lane, )
 Re: Finding bottleneck  ("Merlin Moncure", )
 Re: Finding bottleneck  ("Merlin Moncure", )
  Re: Finding bottleneck  (Tom Lane, )
 Re: Finding bottleneck  ("Merlin Moncure", )

> Kari Lavikka <> writes:
> > samples  %        symbol name
> > 13513390 16.0074  AtEOXact_CatCache
>
> That seems quite odd --- I'm not used to seeing that function at the
top
> of a profile.  What is the workload being profiled, exactly?

He is running a commit_delay of 80000.  Could that be playing a role?

Merlin


В списке pgsql-performance по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: Finding bottleneck
От: Tom Lane
Дата:
Сообщение: Re: Why hash join instead of nested loop?