Re: Postgres Replaying WAL slowly - Mailing list pgsql-performance

From Tom Lane
Subject Re: Postgres Replaying WAL slowly
Date
Msg-id 21474.1404160784@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres Replaying WAL slowly  (Jeff Frost <jeff@pgexperts.com>)
Responses Re: Postgres Replaying WAL slowly  (Jeff Frost <jeff@pgexperts.com>)
List pgsql-performance
Jeff Frost <jeff@pgexperts.com> writes:
> On Jun 30, 2014, at 1:15 PM, Andres Freund <andres@2ndquadrant.com> wrote:
>> So these are probably relations created in uncommitted
>> transactions. Possibly ON COMMIT DROP temp tables?

> That would make sense.  There are definitely quite a few of those being used.

Uh-huh.  I doubt that the mechanism that handles propagation of
AccessExclusiveLocks to the standby is smart enough to ignore locks
on temp tables :-(

> Another item of note is the system catalogs are quite bloated:
> Would that cause the replica to spin on StandbyReleaseLocks?

AFAIK, no.  It's an unsurprising consequence of heavy use of short-lived
temp tables though.

So it seems like we have a candidate explanation.  I'm a bit surprised
that StandbyReleaseLocks would get this slow if there are only a dozen
AccessExclusiveLocks in place at any one time, though.  Perhaps that
was a low point and there are often many more?

            regards, tom lane


pgsql-performance by date:

Previous
From: Jeff Frost
Date:
Subject: Re: Postgres Replaying WAL slowly
Next
From: Jeff Frost
Date:
Subject: Re: Postgres Replaying WAL slowly