Re: Occasional lengthy locking causing stalling on commit - Mailing list pgsql-general

From Ben Hoskings
Subject Re: Occasional lengthy locking causing stalling on commit
Date
Msg-id CACTv1ALEs8s3EW0Up0+hhffwFReckzLEfAafx09WovVT+qxdyg@mail.gmail.com
Whole thread Raw
In response to Re: Occasional lengthy locking causing stalling on commit  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Occasional lengthy locking causing stalling on commit  (Ben Hoskings <ben@hoskings.net>)
List pgsql-general
On Mon, 1 Feb 2021 at 10:33, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> One thing that just occurred to me is that you might find it
> interesting to keep tabs on what's in the $PGDATA/pg_notify
> directory.  Do the performance burps correspond to transitory
> peaks in the amount of data there?  Or (grasping at straws here...)
> wraparound of the file names back to 0000?

We don't have filesystem access on Cloud SQL - the downside of the
managed route :)

It sounds like it might be time to bump the pg13 upgrade up the TODO list.

Cheers
Ben



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Occasional lengthy locking causing stalling on commit
Next
From: Laurenz Albe
Date:
Subject: Re: SV: Npgsql and the Connection Service File