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

[Ludwig Adam]

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,
Ludwig

petaFuel GmbH
Ludwig Adam
Geschäftsführer

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
www.petaFuel.de

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