Postgres Pro
Downloads
Home   >   mailing lists

Re: BufferSync() performance - Mailing list pgsql-general

From Greg Smith
Subject Re: BufferSync() performance
Date
Msg-id alpine.GSO.2.01.0903051658000.28434@westnet.com
Whole thread Raw
In response to BufferSync() performance  (Guido Ostkamp <postgresql@ostkamp.fastmail.fm>)
List pgsql-general
Tree view 
On Thu, 5 Mar 2009, Guido Ostkamp wrote:

> Would this work or is there a special reason why the original check was done
> with lock held?

http://en.wikipedia.org/wiki/Race_condition

Until you have a lock on a buffer header, you can't trust that you're even
seeing consistent information about it.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: BufferSync() performance
Next
From: "Pierre Racine"
Date:
Subject: Keeping only one postgres.exe instance running