Re: pg_am access in simple transaction?

From: pinker <pinker(at)onet(dot)eu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_am access in simple transaction?
Date: 2016-11-25 15:04:46
Message-ID: 1480086286184-5931991.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Moreno Andreo 2016-11-25 15:35:50 Re: Replicating hundreds of thousandw of rows
Previous Message Adrian Klaver 2016-11-25 15:01:04 Re: query locks up when run concurrently