Re: Finding bottleneck

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Finding bottleneck
Дата
Msg-id 28801.1123515439@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Finding bottleneck  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Список pgsql-performance
"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
>> Kari Lavikka <tuner@bdb.fi> 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?

It wouldn't cause AtEOXact_CatCache to suddenly get expensive.  (I have
little or no faith in the value of nonzero commit_delay, though.)

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Finding bottleneck
Следующее
От: Kari Lavikka
Дата:
Сообщение: Re: Finding bottleneck