Re: pgbench

On 10/03/2013 06:21 AM, Simeó Reig wrote:
> Hello
>
> I was doing a performance test with pgbench with a pretty long queries
> and I have the next error:
>
> $ pgbench -n -c1 -T 3 -f veins_pgbench.sql pdn
> Client 0 aborted in state 0: ERROR: syntax error at end of input
> LINE 1: ...(abc.persones.provincia = abc.poblacions.cod_provinc
> ^
> transaction type: Custom query
> scaling factor: 1
> query mode: simple
> number of clients: 1
> number of threads: 1
> duration: 3 s
> number of transactions actually processed: 0
> tps = 0.000000 (including connections establishing)
> tps = 0.000000 (excluding connections establishing)
>
> I believe pgbench has a very low limit with the queries you can put
> inside a file with the 't' option.
> Am I right? How can avoid it ?

Well first you say 't' option but show 'T' option, they are different.

Second the error is reporting a syntax error in your script, so I would
look there first.

>
> My best regards
>
>
> Simeó Reig
> Barcelona (Spain)
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com