| From: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
|---|---|
| To: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: seems like a bug in pgbench -R |
| Date: | 2019-03-15 22:05:28 |
| Message-ID: | 217c49ff-f794-7fb5-4d7b-521fc8afaea4@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 3/15/19 5:16 PM, Fabien COELHO wrote:
>
>>> echo 'select 1' > select.sql
>>>
>>> while /bin/true; do
>>> pgbench -n -f select.sql -R 1000 -j 8 -c 8 -T 1 > /dev/null 2>&1;
>>> date;
>>> done;
>>
>> Indeed. I'll look at it over the weekend.
>>
>>> So I guess this is a bug in 12788ae49e1933f463bc59a6efe46c4a01701b76, or
>>> one of the other commits touching this part of the code.
>
> I could not reproduce this issue on head, but I confirm on 11.2.
>
AFAICS on head it's fixed by 3bac77c48f166b9024a5ead984df73347466ae12
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chapman Flack | 2019-03-16 01:06:22 | Lifespan of a BeginInternalSubTransaction subxact ? |
| Previous Message | Yun Li | 2019-03-15 21:54:19 | Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? |