Re: The number of character limitation of custom script on pgbench

On 11/13/13, 6:18 AM, Sawada Masahiko wrote:
> Hi all,
> 
> The function of custom script of pgbench allows only  BUFSIZ
> (i.g.,1024byte) or less as length of a SQL.
> I think that  when we want to bench mark with long SQL then it will difficult.
> At that time even pgbench doesn't return ERROR. It will try to do
> query with the broken SQL.
> And user can not know why function of custom script is not work fine.
> It look as just error of SQL to user.
> 
> So I'm thinking following solution.
> (1) to increase buffer size
> (2) to change to variable buffer size
> (3) to return ERROR with information

I'd go for #2.  But at least an error.