Re: Very long COMMIT times? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Very long COMMIT times?
Date
Msg-id 29258.1005608607@sss.pgh.pa.us
Whole thread Raw
In response to Re: Very long COMMIT times?  ("Jeff Boes" <jboes@nexcerpt.com>)
List pgsql-admin
"Jeff Boes" <jboes@nexcerpt.com> writes:
>> Did this come about because of the increase in WAL count?

No.

> Oops.  This turns out not to be a COMMIT time, but instead it's happening
> in a NOTIFY operation just after the COMMIT.  What would cause a
> previously-quick NOTIFY step to become many minutes long?

Have you vacuumed pg_listener recently?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Jeff Boes"
Date:
Subject: Re: Very long COMMIT times?
Next
From: "Peter Darley"
Date:
Subject: Postgresql optimization