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

[David Fetter]

On Mon, Oct 16, 2006 at 03:20:39PM +0900, Tatsuo Ishii wrote:
> > 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?
> 
> But in order to know if the transaction is read-only, we need to
> issue show transaction_read_only, which might be costy than parsing
> SQL. No?

I think it would be fairly simple to catch the SET TRANSACTION call :)

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

Remember to vote!