Content-Type: multipart/mixed; boundary="------------bbRgleDgKEeb4k4jHQlOTvaE"
Message-ID: <0865e13a-da93-4ad1-8b93-7b54a1628f04@jbitc.de>
Date: Sun, 23 Aug 2026 11:31:08 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: on 19beta3: repack (concurrently) affects sessions with
 transaction isolation level repeatable read
To: Peter Geoghegan <pg@bowt.ie>
Cc: pgsql-bugs@lists.postgresql.org
References: <5d2060d5-8145-40c6-9a2e-4ddb9f6b0fc9@jbitc.de>
 <CAH2-WzmgX2suoXeyOhT6zp01qtosoo6x2kHxDNPJNcn=Kc3Jwg@mail.gmail.com>
Content-Language: de-DE, en-US
From: Jochen Bandhauer <jb@jbitc.de>
In-Reply-To: 
 <CAH2-WzmgX2suoXeyOhT6zp01qtosoo6x2kHxDNPJNcn=Kc3Jwg@mail.gmail.com>
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/0865e13a-da93-4ad1-8b93-7b54a1628f04%40jbitc.de>
Precedence: bulk

This is a multi-part message in MIME format.
--------------bbRgleDgKEeb4k4jHQlOTvaE
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

On 22.08.2026 21:45, Peter Geoghegan wrote:
> On Sat, Aug 22, 2026 at 3:29 AM Jochen Bandhauer <jb@jbitc.de> wrote:
>> while using repack (concurrently) I found a behavior that I didn't
>> expect. When running a "repack (concurrently) t;" in one session,
>> another session with "transaction isolation level repeatable read"
>> reports sometimes 0 for "select count(*) from t;".
> This is a documented behavior; "repack concurrently" is allowed to
> violate MVCC. There's a warning box about this in the docs for the
> repack command [1], which notes "REPACK with the CONCURRENTLY option
> is not MVCC-safe, see Section 13.6 for details".
>
> [1] https://www.postgresql.org/docs/devel/sql-repack.html
Hello,

thanks, I haven't seen that. I also read that this might change in the 
future [1]. After some further reading I applied patch [2] that worked 
for the test case (The second session always showed the correct number 
of rows).

Jochen

[1] 
https://www.postgresql.org/message-id/202504040733.ysuy5gad55md%40alvherre.pgsql
[2] https://commitfest.postgresql.org/patch/6957/

-- 
Mit freundlichen Grüßen

Jochen Bandhauer
+49 (0)176 29390012
www.jbitc.de

--------------bbRgleDgKEeb4k4jHQlOTvaE
Content-Type: text/vcard; charset=UTF-8; name="jb.vcf"
Content-Disposition: attachment; filename="jb.vcf"
Content-Transfer-Encoding: base64

QkVHSU46VkNBUkQNClZFUlNJT046NC4wDQpOOkJhbmRoYXVlcjtKb2NoZW47OzsNCkZOOkpv
Y2hlbiBCYW5kaGF1ZXINCkVNQUlMO1BSRUY9MTtUWVBFPXdvcms6amJAamJpdGMuZGUNClVS
TDpodHRwczovL3d3dy5qYml0Yy5kZQ0KVEVMO1RZUEU9d29yaztWQUxVRT1URVhUOis0OTE3
NjI5MzkwMDEyDQpUWjpFdXJvcGUvQmVybGluDQpFTkQ6VkNBUkQNCg==

--------------bbRgleDgKEeb4k4jHQlOTvaE--