Re: pg_am access in simple transaction? - Mailing list pgsql-general

From pinker
Subject Re: pg_am access in simple transaction?
Date
Msg-id 1480086286184-5931991.post@n3.nabble.com
Whole thread Raw
In response to Re: pg_am access in simple transaction?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: pg_am access in simple transaction?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Adrian Klaver-4 wrote
> I can not replicate using 50 clients instead of 2000. I suspect either
> has to do with the extreme number of clients or it is an artifact of
> from some other process.

And I have replicated it with 50 clients as well... lsof output:

51 data/base/13328/2601

command: watch 'lsof -e /run/user/1001/gvfs +D data|awk "{print
\$NF}"|sort|uniq -c|sort -nr'

Maybe our versions of PostgreSQL differs? I use "PostgreSQL 9.5.4 on
x86_64-redhat-linux-gnu, compiled by gcc (GCC) 6.1.1 20160621 (Red Hat
6.1.1-3), 64-bit"




--
View this message in context: http://postgresql.nabble.com/pg-am-access-in-simple-transaction-tp5931974p5931991.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: query locks up when run concurrently
Next
From: Moreno Andreo
Date:
Subject: Re: Replicating hundreds of thousandw of rows