Re: Very long COMMIT times?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jeff Boes" <jboes(at)nexcerpt(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Very long COMMIT times?
Date: 2001-11-12 23:43:27
Message-ID: 29258.1005608607@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Jeff Boes" <jboes(at)nexcerpt(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Darley 2001-11-13 15:35:57 Postgresql optimization
Previous Message Jeff Boes 2001-11-12 23:00:48 Re: Very long COMMIT times?