| From: | legrand legrand <legrand_legrand(at)hotmail(dot)com> |
|---|---|
| To: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | pg_stat_statements: duplicated external query texts with MSY2 |
| Date: | 2020-06-08 21:28:45 |
| Message-ID: | PR3PR01MB6426697AE2792766C67B8B3A90850@PR3PR01MB6426.eurprd01.prod.exchangelabs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hello,
I met a stange behavior with testing pg_stat_statements (default setup) with pgbench on my MSYS2 build
(PostgreSQL 13beta1 on x86_64-w64-mingw32, compiled by x86_64-w64-mingw32-gcc.exe (Rev2, Built by MSYS2 project) 9.2.0, 64-bit).
pgbench -i postgres
pgbench -c20 -t5 postgres
generates the attached pgss_query_texts.stat,
where "BEGIN" and "UPDATE pgbench_accounts SET abalance = abalance + $1 WHERE aid = $2"
appears 20 times ...
It does not seem to appear on linux, and I'm not able to juge if its specific to this port, and if its always limited ...
Regards
PAscal
| Attachment | Content-Type | Size |
|---|---|---|
| pgss_query_texts.stat | application/octet-stream | 2.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2020-06-08 21:36:39 | Re: BUG #16486: Prompted password is ignored when password specified in connection string |
| Previous Message | PG Bug reporting form | 2020-06-08 19:06:48 | BUG #16487: EXPLAIN produces JSON with duplicate "Workers" arrays |