Re: debugging intermittent slow updates under higher load

Поиск
Список
Период
Сортировка
От Chris Withers
Тема Re: debugging intermittent slow updates under higher load
Дата
Msg-id 7c2f13a0-cf45-0124-5f92-ad46836bd925@withers.org
обсуждение исходный текст
Ответ на Re: debugging intermittent slow updates under higher load  (Rene Romero Benavides <rene.romero.b@gmail.com>)
Список pgsql-general
On 05/12/2018 15:47, Rene Romero Benavides wrote:
> Also read about hot updates and the storage parameter named 
> "fill_factor", so, data blocks can be recycled instead of creating new 
> ones if the updated fields don't update also indexes.

I have read about these, but I'd prefer not to be making 
opportunistic/guessing changes on this.

How can I collect metrics/logging/etc evidence to confirm what the 
problem actually is?

cheers,

Chris


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

Предыдущее
От: Chris Withers
Дата:
Сообщение: Re: debugging intermittent slow updates under higher load
Следующее
От: Slavcho Trnkovski
Дата:
Сообщение: Re: postgis after pg_upgrade