Re: locks within select

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: locks within select
Date: 2021-12-14 06:29:34
Message-ID: CAKFQuwbPCNFALoj5vsR5ONYfMEUwzgP8OTjT1Ud=bvZZQLDWag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday, December 13, 2021, Marc Millas <marc(dot)millas(at)mokadb(dot)com> wrote:
>
> I was wondering if for example, within a join, some kind of lock may be
> acquired so that the dataset concerned is not changed during execution ?
> (for example a delete then autovacuum ??)
>

Read this primer on MVCC from the docs:

https://www.postgresql.org/docs/current/mvcc-intro.html

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Klaudie Willis 2021-12-14 08:16:08 Re: When Update balloons memory
Previous Message Dilip Kumar 2021-12-14 05:40:12 Re: log shipping with pg_receivewal