Re: debugging intermittent slow updates under higher load - Mailing list pgsql-general

From Chris Withers
Subject Re: debugging intermittent slow updates under higher load
Date
Msg-id 7c2f13a0-cf45-0124-5f92-ad46836bd925@withers.org
Whole thread Raw
In response to Re: debugging intermittent slow updates under higher load  (Rene Romero Benavides <rene.romero.b@gmail.com>)
List 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 by date:

Previous
From: Chris Withers
Date:
Subject: Re: debugging intermittent slow updates under higher load
Next
From: Slavcho Trnkovski
Date:
Subject: Re: postgis after pg_upgrade