Re: Idea for better handling of cntxDirty - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Idea for better handling of cntxDirty
Date
Msg-id 10841.1037130594@sss.pgh.pa.us
Whole thread Raw
In response to Idea for better handling of cntxDirty  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
"Mikheev, Vadim" <VMIKHEEV@sectordata.com> writes:
>> Wouldn't it work for cntxDirty to be set not by LockBuffer, but by
>> XLogInsert for each buffer that is included in its argument list?

> I thought to add separate call to mark context dirty but above
> should work if all callers to XLogInsert always pass all
> modified buffers - please check.

AFAICT it is safe.  There are some places (in sequences and btree)
where not all the modified buffers are explicitly listed in XLogInsert's
arguments, but redo of those types of WAL records will always reinit the
affected pages anyway.  So we don't need to worry about forcing
checkpoint to write the pages early.

In general I don't think this adds any fragility to the system.  A WAL
record that is not set up to restore all buffers modified by the logged
operation would be broken by definition, no?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Curtis Faith"
Date:
Subject: Prepare enabled pgbench
Next
From: Jakub Ouhrabka
Date:
Subject: Re: ecpg "problem" ...