Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1qpn0I-006ynw-Lz
	for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Oct 2023 09:56:46 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1qpn0G-00C9Jp-AK
	for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Oct 2023 09:56:45 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <alvherre@alvh.no-ip.org>)
	id 1qpn0F-00C9J0-Ut
	for pgsql-bugs@lists.postgresql.org; Mon, 09 Oct 2023 09:56:44 +0000
Received: from out4-smtp.messagingengine.com ([66.111.4.28])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <alvherre@alvh.no-ip.org>)
	id 1qpn0D-000lWf-WA
	for pgsql-bugs@lists.postgresql.org; Mon, 09 Oct 2023 09:56:43 +0000
Received: from compute5.internal (compute5.nyi.internal [10.202.2.45])
	by mailout.nyi.internal (Postfix) with ESMTP id BA6425C0175;
	Mon,  9 Oct 2023 05:56:40 -0400 (EDT)
Received: from mailfrontend1 ([10.202.2.162])
  by compute5.internal (MEProxy); Mon, 09 Oct 2023 05:56:40 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:cc:content-transfer-encoding
	:content-type:content-type:date:date:feedback-id:feedback-id
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1696845400; x=
	1696931800; bh=Blxrk6gwsrDoe00p449b7CVTVG0ClZSVxE/3vThe5kU=; b=F
	wfAGSC3TEKa243atsi5Td+3WA4bAbx1arglFt3vQtLoBNr/R/3RWXDP5gCCMm5V6
	GPpZaraTPy3CK3IhRt8iapV+FhsIdX76hUSz9VI7Cv2EKkOwI9zdxyht+5Q39KXc
	QtBxalMal7jShb2teoRWddpioxGwftWfvgR9E6XvcBULjy1F9Z/o5WZYzIqPrThc
	l+7fD/jljcZudPksqwC0SAgbzmsR8UuQB90kKv0ADDNCd2GXuAld+b0WIRRM4qbB
	YOKXJ/Ivvd19yo1VOVxp7b8wV5YoQLtxzhWo5EjcLCuDFCMlo53aJuE8OcEHVt5W
	Pgslp0O0nuRb6vdAxFPag==
X-ME-Sender: <xms:WM4jZQ1Q1ZljloBPDr9OnRmciArA6kbtaSMxkgq7ofDkYgXAfFYm8A>
    <xme:WM4jZbHfsH8X0ECqpmx1mH3t4vDCD13vlCC89drC8QRD1CGDeqMVB-VU21aAWUsCI
    2csNjCXojaojXlDGA>
X-ME-Received: 
 <xmr:WM4jZY6c1PNcLP5vesPD3h3NZM4G0Z3iBrFpdCyqpO-JN49MiG_bZu_EiYv2fp4she-TPnyCupONPxyY7zFqNjMdupe_YPzYaslURBDfGwp6ZrPzxW1uBvdiE0kwzwZMXr4>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgedvkedrheefgddvudcutefuodetggdotefrodftvf
    curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu
    uegrihhlohhuthemuceftddtnecunecujfgurhepfffhvfevuffkgggtugfgjgesthekre
    dttddtjeenucfhrhhomheptehlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgv
    segrlhhvhhdrnhhoqdhiphdrohhrgheqnecuggftrfgrthhtvghrnhepkeefieehkeekff
    dtffeggedtffelkeeigfduvdekgfdugfeluedtiefhkeetudfgnecuffhomhgrihhnpehg
    ihhthhhusgdrtghomhdpvghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluhhsthgvrh
    fuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgvsegrlhhv
    hhdrnhhoqdhiphdrohhrgh
X-ME-Proxy: <xmx:WM4jZZ2o-ZH4ssyTq9BTx8aIeVn8GWzpoB26RTuVBEooix0w7LHU4g>
    <xmx:WM4jZTGdyUd6MJwyLbwG3NnfFtvbMXLkgxU-j7A4v7AyYe82TfouUw>
    <xmx:WM4jZS-QJJx7Chye0IF8YOlkPUJI7g6G37dVuREhkSgkdi-NTKYVDw>
    <xmx:WM4jZWN9d3ZrOWI5oK2QjgIyl3vHgq0UAfrm9SzgpgrJ1o7dtzMvMA>
Feedback-ID: ia2694551:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon,
 9 Oct 2023 05:56:39 -0400 (EDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org;
	s=schmee; t=1696845398;
	bh=ACney6ZLLWQLbS+HZSharMCiihJXoy6R0XUj0fz5cqk=;
	h=Date:From:To:Cc:Subject:In-Reply-To:From;
	b=Sj6YOb5Af9O+XmsgzTtvfYKRRHsnI6g0BWsZcOfW2zveHrb2x6DCW5xMVzNeZBUaQ
	 jcMTzafqvfuhS67x5UvLiRAQq37dg6DOIZLzyrL0j2G7WVN7MmpAiNtHTENmyen71s
	 fTIEPdPHmjC5R0Wn/z9Wo1/uwk3YXbCXw3QrbozoCzPreIM+aHmVWDlytZ0/KMeV1V
	 PpkrRwfk/hvEaGCgvgRwJ2qDO2u+X+lIA5syZUtmkNClyA177hDmEpwcaXDMaPXB0T
	 Ro1AW23zXnOT5qrU9dIq9jnhGfpsXUaxDTRgAoJ6WWcY95oIFMj37zuh0w7PJzo8ru
	 n68Tf2mONCH2g==
Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000)
	id AE76D3146; Mon,  9 Oct 2023 11:56:38 +0200 (CEST)
Date: Mon, 9 Oct 2023 11:56:38 +0200
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Matthias Apitz <guru@unixarea.de>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Access to old versions of a row
Message-ID: <202310090956.3rwqgnavanez@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <ZSLJ80xFka2Pqan1@c720-1400094.fritz.box>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/202310090956.3rwqgnavanez%40alvherre.pgsql>
Precedence: bulk

On 2023-Oct-08, Matthias Apitz wrote:

> 
> As long as the vacuum is not run, older versions of a given row should
> be "somewhere". Is there a way to read them?

Maybe with 
https://github.com/df7cb/pg_dirtyread

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/