Re: Cross-database SERIALIZABLE safe snapshots

2024-01-20 Thread vignesh C
On Mon, 10 Jul 2023 at 14:48, Heikki Linnakangas wrote: > > On 09/03/2023 07:34, Thomas Munro wrote: > > Here is a feature idea that emerged from a pgsql-bugs thread[1] that I > > am kicking into the next commitfest. Example: > > > > s1: \c db1 > > s1: CREATE TABLE t (i int); > > s1: BEGIN TRANSA

Re: Cross-database SERIALIZABLE safe snapshots

2023-07-10 Thread Heikki Linnakangas
tech) From 7976215833c153d97c3d6de95bcfc17d2d530490 Mon Sep 17 00:00:00 2001 From: Thomas Munro Date: Thu, 9 Mar 2023 18:12:17 +1300 Subject: [PATCH v2 1/3] Optimize cross-database SERIALIZABLE safe snapshots. SERIALIZABLE READ ONLY [DEFERRABLE] transactions can benefit from "safe snapshots

Cross-database SERIALIZABLE safe snapshots

2023-03-08 Thread Thomas Munro
ly on that fact elsewhere if reconsidering that. [1] https://www.postgresql.org/message-id/flat/17368-98a4f99e8e4b4402%40postgresql.org From 2156a432b3629d1b7f8bf2fe42f641f8845baf48 Mon Sep 17 00:00:00 2001 From: Thomas Munro Date: Thu, 9 Mar 2023 18:12:17 +1300 Subject: [PATCH] Optimize cross-databa