[pgpool-general: 337] Load balancing of user defined functions

Ludwig Adam ludwig.adam at petafuel.de
Tue Apr 3 16:41:02 JST 2012

Dear members of the mailing list,

we have now successfully setup a full HA-solution for Postgres incorporating two pg-pool-II instances (heatbeat based fail-over) and a master-slave streaming replication.
So far, everything works like a charm. However we would now like to enable the load balancing feature of pg-pool if possible.

In general, all of our applications are not using direct SQL or prepared statements but instead are calling user defined functions to do their work.
So basically all calls are Execute some_function(with, some, parameters). In the UDF we have the actual SQL statements then, the updates, inserts and selects...

Is there a chance that we can do a load balancing of these functions?

Best regards,

petaFuel GmbH
Ludwig Adam

Münchner Strasse 4
85354 Freising

Tel.: +49 (0) 8161 4060 - 202               Mobil: +49 (0) 179-22 911 02
Fax: +49 (0) 8161 4060 - 401               eMail: ludwig.adam at petafuel.de<mailto:ludwig.adam at petafuel.de>

Geschäftsführer: Ludwig Adam, Dr. Peter Schönweitz
Amtsgericht München, HRB 133773

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120403/9295c30a/attachment.html>

More information about the pgpool-general mailing list