pgbench

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)

Responses

  • Re: pgbench at 2013-10-03 13:51:36 from Adrian Klaver

Browse pgsql-general by date

  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