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

[Tatsuo Ishii]

> 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?
--
Tatsuo Ishii
SRA OSS, Inc. Japan