[pgpool-general: 2392] Re: pgpool II clustering + replication - poor performance

[Tatsuo Ishii]

> 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;
> 
> Returns:
> 
> 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 ...

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> 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 +
>> :range;").
>>
>> 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
>>