RE: Concurrent-update problem in bufmgr.c - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: Concurrent-update problem in bufmgr.c
Date
Msg-id 8F4C99C66D04D4118F580090272A7A23018CF8@SECTORBASE1
Whole thread Raw
In response to Concurrent-update problem in bufmgr.c  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> I believe the correct fix for this problem is for bufmgr.c to grab
> a read lock (BUFFER_LOCK_SHARED) on any page that it is writing out.
> A read lock is sufficient since there's no need to prevent other
> backends from reading the page, we just need to prevent them from
> changing it during the I/O.
> 
> Comments anyone?

Do it.

Vadim


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef?
Next
From: Hiroshi Inoue
Date:
Subject: Re: psql's \d functions broken for views in current sources