[Pgpool-hackers] READ ONLY transactions: A Model for Pgpool

David Fetter david at fetter.org
Mon Oct 16 05:16:46 UTC 2006


Hello,

I noticed that pgpool does some SQL source filtering in order to
discover whether a transaction is read-only or not.  Could we see
about changing this so that people would set the transaction to be
READ ONLY when people want it to be read-only?  That way, there would
be a short and deterministic step rather than a long one involving
parsing SQL.

Could this go into the next version of pgpool?

Regards,
David.
-- 
David Fetter <david at fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!


More information about the Pgpool-hackers mailing list