Re: pgpool-II: cannot use serializable mode in a hot standby

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: kgrittn(at)gmail(dot)com
Cc: alp(at)rsu(dot)ru, adrian(dot)klaver(at)aklaver(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: pgpool-II: cannot use serializable mode in a hot standby
Date: 2016-04-13 23:15:13
Message-ID: 20160414.081513.1083372833252401057.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2016-04-13 23:20:54 Re: [HACKERS] sign function with INTERVAL?
Previous Message FarjadFarid(ChkNet) 2016-04-13 22:59:35 Re: I/O - Increase RAM