Re: pgbench - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: pgbench
Date
Msg-id 20131003155055.GT5235@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: pgbench  (Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>)
Responses Re: pgbench  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pgbench  (Simeó Reig <simeo.reig@grupoincofisa.com>)
List pgsql-general
Giuseppe Broccolo wrote:

> The format of the script file has to be one SQL command per line;
> multiline SQL commands are not supported, and empty lines are
> ignored. This could bring to errors. Could this be your case?

Multiline SQL commands are not supported?  Well that sucks, because only
BUFSIZ chars are read from each line.  In my platform that's 8192, but
maybe in Simeó's case it's shorter .. or maybe his query really is
longer than 8192 bytes.

This smells like a pgbench bug to me.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pgbench
Next
From: Tom Lane
Date:
Subject: Re: pgbench