Yeb Havinga wrote:
3. Like 1 but with the use of a connection pooler like pgpool. Not
sure if pgpool supports asynchronous queries, but that would help as
well by pulling data from the 13 databases in parallel instead of
serial: get the queries onto the 13 servers without waiting for
results, then as soon as data is ready, get results and display.
of course, you'd need a separate pool for each database.
then there's
4... use dblink to query these other databases from within one
master one.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
