[pgpool-general: 1391] Re: Parallel query with existing data

Tatsuo Ishii ishii at postgresql.org
Fri Feb 15 09:34:43 JST 2013

[Cc:ed to pgpool-general list]


Please submit questions to pgpool list.

> Hi,
> I haven't been able to find any tutorials showing how to take an existing database and put it into parallel query mode.  Do I set up the nodes, then pg_restore to pgpool -OR- copy complete database to each node, create partitioning rules, then manually delete tuples in each database according to those rules?  -OR- does pgpool automatically delete tuples from distributed nodes after partitioning rules have been setup?
> Thanks,
> Ramos Mays
> 314.494.0228

After set up parallel query mode, execute pg_restore via pgpool.
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

More information about the pgpool-general mailing list