From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | pinker <pinker(at)onet(dot)eu>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_am access in simple transaction? |
Date: | 2016-11-25 15:42:11 |
Message-ID: | 961fbfe0-578f-3b6d-ef78-5eb23683abb3@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/25/2016 07:04 AM, pinker wrote:
> 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"
No the the versions are the same. It is PEBKAC issue, I was logged in as
wrong user. Running your watch command(minus the -e part which my
version of lsof does not understand) while the Bash script is running
gets the same results. A little digging found that it is used in psql by
describe.c and tab-complete.c:
So are other system catalogs, not sure why this one is showing up?
>
>
>
>
> --
> 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.
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-11-25 17:24:17 | Re: pg_am access in simple transaction? |
Previous Message | Moreno Andreo | 2016-11-25 15:35:50 | Re: Replicating hundreds of thousandw of rows |