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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: The number of character limitation of custom script on pgbench
Date: 2013-11-13 13:23:44
Message-ID: 52837D60.1040604@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2013-11-13 13:27:57 Re: The number of character limitation of custom script on pgbench
Previous Message Rajeev rastogi 2013-11-13 13:09:19 Standalone synchronous master