| From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pgbench - minor fix for meta command only scripts |
| Date: | 2017-09-11 08:49:42 |
| Message-ID: | alpine.DEB.2.20.1709111044310.32517@lancre |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello Jeff,
Ok, the problem was a little bit more trivial than I thought.
The issue is that under a low rate there may be no transaction in
progress, however the wait procedure was relying on select's timeout. If
nothing is active there is nothing to wait for, thus it was an active loop
in this case...
I've introduced a usleep call in place of select for this particular
case. Hopefully this is portable.
ISTM that this bug exists since rate was introduced, so shame on me and
back-patching should be needed.
--
Fabien.
| Attachment | Content-Type | Size |
|---|---|---|
| pgbench-rate-bug-2.patch | text/x-diff | 1.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christoph Berg | 2017-09-11 08:53:39 | Re: mysql_fdw + PG10: unrecognized node type: 217 |
| Previous Message | Amit Langote | 2017-09-11 08:46:57 | Re: Partition-wise join for join between (declaratively) partitioned tables |