On Jun 30, 2014, at 1:39 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > > >> 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. > Yah, this has been an issue in the past, so we tend to cluster them regularly during off-hours to minimize the issue. > 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? > > Entirely possible that it was a low point. We'll set up some monitoring to track the number of AccessExclusiveLocks and see how much variance there is throughout the day.
