Re: Occasional lengthy locking causing stalling on commit

From: Ben Hoskings <ben(at)hoskings(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Occasional lengthy locking causing stalling on commit
Date: 2021-02-01 01:33:51
Message-ID: CACTv1ALEs8s3EW0Up0+hhffwFReckzLEfAafx09WovVT+qxdyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 1 Feb 2021 at 10:33, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ayagmur75 2021-02-01 05:34:51 Re: Offlne Slony Installation
Previous Message Tom Lane 2021-01-31 23:33:54 Re: Occasional lengthy locking causing stalling on commit