From: | Simeó Reig <simeo(dot)reig(at)grupoincofisa(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | pgbench |
Date: | 2013-10-03 13:21:18 |
Message-ID: | c7576ae69ced88ce09cb8c004145a460@mailserver.grupoincofisa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 ?
My best regards
Simeó Reig
Barcelona (Spain)
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2013-10-03 13:51:36 | Re: pgbench |
Previous Message | David Johnston | 2013-10-03 13:10:51 | Re: Unable to convert xpath value to date |