Bug in intarray bench script

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Bug in intarray bench script
Date: 2016-05-17 09:18:17
Message-ID: B97BDCB7-A3B3-4734-90B5-EDD586941629@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

In the contrib/intarray benchmarking script bench.pl, the -e option to print
the plan via EXPLAIN is using the DBI do() method which discards output
resulting in nothing being printed. Judging by the usage help (“show explain”)
I assume the intention is to print the plan to STDOUT when invoked (which is
exactly what I wanted in this case, thus bumping into this) but at least on
recent DBI/DBD::Pg versions the do() method is not returning the rows.

Attached patch use the selectall_arrayref() method instead and output the plan
when -e is invoked.

cheers ./daniel

Attachment Content-Type Size
intarray_bench.diff application/octet-stream 390 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Nasby 2016-05-17 14:38:28 Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors)
Previous Message Amit Langote 2016-05-17 07:56:34 Re: Declarative partitioning