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

From Sawada Masahiko
Subject The number of character limitation of custom script on pgbench
Date
Msg-id CAD21AoDs-7gyWHqwXvArEjYsToivQdjRVNSpz_pMp0XbLmgPNQ@mail.gmail.com
Whole thread Raw
Responses Re: The number of character limitation of custom script on pgbench  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
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

Thought?


Regards,

-------
Sawada Masahiko



pgsql-hackers by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: [OT] why not keeping the original column name in catalog after a drop?
Next
From: Jeremy Harris
Date:
Subject: Re: Fast insertion indexes: why no developments