pgbench - Mailing list pgsql-general

From Simeó Reig
Subject pgbench
Date
Msg-id c7576ae69ced88ce09cb8c004145a460@mailserver.grupoincofisa.com
Whole thread Raw
Responses Re: pgbench  (Adrian Klaver <adrian.klaver@gmail.com>)
List 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)


pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Unable to convert xpath value to date
Next
From: Adrian Klaver
Date:
Subject: Re: pgbench