A 2013-10-03 16:16, Adrian Klaver escrigué:
On 10/03/2013 07:11 AM, Simeó Reig wrote:
A 2013-10-03 15:51, Adrian Klaver escrigué:
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.
Yes, I did I mistake. I would say 'f' option (file option) not 't'
option, sorry . But no, there is no mistake with the script, I can
do:
# psql -d pdn < veins_pgbench.sql
and it works perfectly
thanks Adrian, I'm almost sure that the problem is the query is too
long
for pgbench (1600 characters)
You have not shown the query, but could you be running into the belwo:
http://www.postgresql.org/docs/9.3/interactive/pgbench.html
"The format of a script file is one SQL command per line; multiline
SQL commands are not supported. Empty lines and lines beginning with
-- are ignored. Script file lines can also be "meta commands", which
are interpreted by pgbench itself, as described below."
I did it, and I read it all ... I'm use to work with postgresql and
freeBSD world since too years ago ;-)
Thanks again Adrian
Simeó Reig
Barcelona (Spain)
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
