Re: pgpool-II: cannot use serializable mode in a hot standby - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: pgpool-II: cannot use serializable mode in a hot standby
Date
Msg-id 20160414.081513.1083372833252401057.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: pgpool-II: cannot use serializable mode in a hot standby  (Kevin Grittner <kgrittn@gmail.com>)
List pgsql-general
> It should not forward transactions which are requested to be
> SERIALIZABLE to standbys.  If you just suppress the SET statement
> (or substitute REPEATABLE READ), queries in that transaction can
> return incorrect results.

Yes. Once "SET default_transaction_isolation to serializable" (or its
variants) are issued, pgpool-II will redirect all subsequent queries
to the primary server until the transaction ends.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


pgsql-general by date:

Previous
From: "FarjadFarid\(ChkNet\)"
Date:
Subject: Re: I/O - Increase RAM
Next
From: "David G. Johnston"
Date:
Subject: Re: [HACKERS] sign function with INTERVAL?