Re: BufferSync() performance

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Guido Ostkamp <postgresql(at)ostkamp(dot)fastmail(dot)fm>
Cc: pgsql-general(at)postgresql(dot)org, bruce(at)momjian(dot)us
Subject: Re: BufferSync() performance
Date: 2009-03-05 22:05:18
Message-ID: alpine.GSO.2.01.0903051658000.28434@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-03-06 00:52:55 Re: Keeping only one postgres.exe instance running
Previous Message Pierre Racine 2009-03-05 21:52:00 Keeping only one postgres.exe instance running