only thing I've found so far on them is this old pgsql-general thread
wherein Tom Lane essentially just says, "Yeah, it can happen and is an
implementation detail that can change from version to version." That was
on 9.4.x and the my most recent confirmed sighting was on a server run
s setting
> old_snapshot_threshold to any value at all besides zero. (On 12+ you can
> directly control the truncation behavior.)
>
> -Jeremy
>
Thanks for the tip!
--
Erik Jones
mag...@gmail.com
On Fri, May 10, 2019 at 12:41 PM Tom Lane wrote:
> Andres Freund writes:
> > On 2019-05-09 13:03:50 -0700, Erik Jones wrote:
> >> The question then is: Why would these user queries be waiting on an
> >> AccessShare lock on pg_attribute?
>
> > Queries that
Hi Andres,
Thank you very much! That's exactly what I needed.
On Fri, May 10, 2019 at 12:14 PM Andres Freund wrote:
> Hi,
>
> On 2019-05-09 13:03:50 -0700, Erik Jones wrote:
> > The question then is: Why would these user queries be waiting on an
> > AccessShare lock
se queries are
being sent as single query transactions via this Node.js postgres adapter:
https://github.com/brianc/node-postgres which is pretty bare bones.
--
Erik Jones
mag...@gmail.com