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.klaver@gmail.com