[pgpool-general: 9232] Re: PGPOOL load

[Ilko Krastev]

Is there anything special with your use-case?
No, there is noting special

Maybe large number of cucurrent COPY?
There is no so mutch concurent copy commands and every copy command copy the data in own temp table.
Normaly every file contacts between 10000 and 100000, but some has 500000 rows.

The load is happen every time, even there is no load on pool and when run single copy from file with 100000 rows.

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