[pgpool-general: 9231] Re: PGPOOL load

[Tatsuo Ishii]

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