Bug in intarray bench script - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Bug in intarray bench script
Date
Msg-id B97BDCB7-A3B3-4734-90B5-EDD586941629@yesql.se
Whole thread Raw
Responses Re: Bug in intarray bench script  (Andreas 'ads' Scherbaum <ads@pgug.de>)
List 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

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Declarative partitioning
Next
From: Jim Nasby
Date:
Subject: Re: HeapTupleSatisfiesToast() busted? (was atomic pin/unpin causing errors)