[pgpool-general: 9233] Re: PGPOOL load

[Tatsuo Ishii]

Does pgpool and PostgreSQL run on the same server?
What versions of pgpool and PostgreSQL?

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

> You can see 1min load every pick is import.
> 
> On 21.10.24 13:45, Tatsuo Ishii wrote:
>> Hi,
>>
>>> Hi
>>>
>>> COPY table TO 'file';
>>> COPY table FROM 'file';
>>>
>>> I make it like this, but  has a problem with load of pool.
>> I have no problem with COPY TO 1.2GB table.
>>
>> test=# select pg_size_pretty(pg_relation_size('pgbench_accounts'));
>>   pg_size_pretty
>> ----------------
>>   1281 MB
>> (1 row)
>>
>> test=# copy pgbench_accounts to '/tmp/copy.out';
>> COPY 10000000
>>
>> Is there anything special with your use-case?
>> Maybe large number of cucurrent COPY?
>>
>> Best reagards,
>> --
>> Tatsuo Ishii
>> SRA OSS K.K.
>> English: http://www.sraoss.co.jp/index_en/
>> Japanese:http://www.sraoss.co.jp