> We are occasionally seeing heavy CPU contention with hundreds of processes
> active but waiting on a lightweight lock - usually lock manager or buffer
> mapping it seems. This is happening with VMs configured with about 64 CPUs,
> 350GBs ram, and while we would typically only have 30-100 concu
On Wed, Apr 6, 2022 at 6:31 PM Adrian Klaver
wrote:
> On 4/6/22 3:28 PM, Chris Bisnett wrote:
> > On Wed, Apr 6, 2022 at 6:24 PM Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote:
>
> >
> > It can:
> >
> >
> https://www.p
On Wed, Apr 6, 2022 at 6:24 PM Adrian Klaver
wrote:
> On 4/6/22 3:13 PM, Chris Bisnett wrote:
> > Hi all!
> >
> > I have several large tables (1-2Tb) that are 99.9% writes (small number
> > of updates) with a decent commit rate (20K/sec). The basic idea is that
> &
Hi all!
I have several large tables (1-2Tb) that are 99.9% writes (small number of
updates) with a decent commit rate (20K/sec). The basic idea is that it’s
generating a lot of data continuously. When the table would reach the
thresholds for autovacuum a vacuum would start and would start generati
