[pgpool-general: 9235] Re: PGPOOL load

[Tatsuo Ishii]

How long your COPY takes and what's the value for num_init_children?

If the COPY takes long time and there are many clients waiting for
connecting to pgpool, then as soon as the COPY finished and exits the
session, all pgpool child process will be waken up and it makes the
load average high.

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

> Hi
> 
> Does pgpool and PostgreSQL run on the same server?
> 
> No
> 
> What versions of pgpool and PostgreSQL?
> Pool version is pgpool-II version 4.3.5 (tamahomeboshi)
> Postgresql 16
> 
> On 21.10.24 14:41, Tatsuo Ishii wrote:
>> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general