Re: The number of character limitation of custom script on pgbench - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: The number of character limitation of custom script on pgbench
Date
Msg-id 52837D60.1040604@gmx.net
Whole thread Raw
In response to The number of character limitation of custom script on pgbench  (Sawada Masahiko <sawada.mshk@gmail.com>)
Responses Re: The number of character limitation of custom script on pgbench  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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.




pgsql-hackers by date:

Previous
From: Steve Singer
Date:
Subject: Re: logical changeset generation v6.5
Next
From: Tom Lane
Date:
Subject: Re: The number of character limitation of custom script on pgbench