Database Horizon - Mailing list pgsql-general

From Goti
Subject Database Horizon
Date
Msg-id CAOzfMuqRe6SLMy=WvPFQb56SiJ=8M7Ru1crdTLSUYx8xcMFCoA@mail.gmail.com
Whole thread Raw
Responses Re: Database Horizon
List pgsql-general
Hi,

I was reading through snapshot chapter in Egor Rogov's postgres internals and there I came across the below.. I am not sure how this is possible and how can I reproduce? Can someone explain the below 2 points if possible?

A real transaction at the Read Committed isolation level holds the database horizon in the same way, even if it is not executing any operators (being in the “idle in trasaction” state).

A virtual transaction at the Read Committed isolation level holds the horizon only while executing operators.

Thanks,

Goti

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: PCI-DSS Requirements
Next
From: Ron
Date:
Subject: pg_dump failed with error code 255, but I don't see why