Re: debugging intermittent slow updates under higher load

From: Chris Withers <chris(at)withers(dot)org>
To: Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com>, bashtanov(at)imap(dot)cc
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: debugging intermittent slow updates under higher load
Date: 2018-12-06 08:29:49
Message-ID: 7c2f13a0-cf45-0124-5f92-ad46836bd925@withers.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Slavcho Trnkovski 2018-12-06 08:40:50 Re: postgis after pg_upgrade
Previous Message Chris Withers 2018-12-06 08:28:44 Re: debugging intermittent slow updates under higher load