Re: CLOG contention, part 2 - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: CLOG contention, part 2
Date
Msg-id CAHyXU0wukkdwBkUSFcFUeF_H+cpa_nKJz0d3=FZ9eXzuy2r=XQ@mail.gmail.com
Whole thread Raw
In response to Re: CLOG contention, part 2  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: CLOG contention, part 2
List pgsql-hackers
On Fri, Jan 27, 2012 at 4:05 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
> Also, I think the general approach is wrong.  The only reason to have
> these pages in shared memory is that we can control access to them to
> prevent write/write and read/write corruption.  Since these pages are
> never written, they don't need to be in shared memory.   Just read
> each page into backend-local memory as it is needed, either
> palloc/pfree each time or using a single reserved block for the
> lifetime of the session.  Let the kernel worry about caching them so
> that the above mentioned reads are cheap.

right -- exactly.  but why stop at one page?

merlin


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Dry-run mode for pg_archivecleanup
Next
From: Tareq Aljabban
Date:
Subject: Re: Configuring Postgres to Add A New Source File