[pgpool-general: 9234] Re: PGPOOL load

[Ilko Krastev]

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