[pgpool-general: 2392] Re: pgpool II clustering + replication - poor performance
ishii at postgresql.org
Fri Jan 10 09:55:10 JST 2014
> That script doesn't work, there appears to be some syntax errors:
> 1) Each line starts with the YEN symbol ( ¥ ), I'm assuming that's meant to
> be a backslash ( \ ) ?
You are right.
> 2) \setrandom isn't a valid command, I'm assuming that's meant to be \set
> random ?
> 3) SELECT count(abalance) FROM pgbench_accounts WHERE aid BETWEEN :aid and
> :aid + :range;
> ERROR: syntax error at or near ":"
> LINE 1: ...) FROM pgbench_accounts where aid between aid and :aid + 200...
The script file is for pgbench, not for psql. i.e. pgbench -f file_name ...
SRA OSS, Inc. Japan
> Thanks in advance for your assistance.
> On 7 January 2014 19:45, Tatsuo Ishii <ishii at postgresql.org> wrote:
>> > Hi Tatsuo,
>> > Thank you for your pgbench results.
>> > Is there any chance you could share your benchmark script with me?
>> It's already in my previous message ("¥set nbranches :scale" ... "SELECT
>> count(abalance) FROM pgbench_accounts WHERE aid BETWEEN :aid and :aid +
>> You save the contents in a file, say "ro_script" then pass to pgbench
>> like "pgbench -f ro_script".
>> > I'm assuming it would require some sample data?
>> No. You can initialize the table by running "pgbench -i -s 1000".
>> > Sent from my iPhone
>> >> On 7 Jan 2014, at 7:36 pm, Tatsuo Ishii <ishii at postgresql.org> wrote:
>> >> Tatsuo
More information about the pgpool-general