In the BufferDesc struct, there seem to be two ways to mark a buffer
page as dirty: setting the BM_DIRTY bit mask in the 'flags' field of the
struct, and setting the 'cntxDirty' field to true. What is the
difference between these two indications of a page's dirtiness?
Or, more to the point, is there a reason we have two ways to do what
looks like the same thing?
BTW, I'd like to remove the behavior that LockBuffer(buf, EXCLUSIVE)
automatically marks the page as dirty. Since there are some situations
in which we acquire an exclusive buffer lock but don't actually end up
modifying the page, this results in dirtying more buffers than are
necessary. I think it's also good practise for code that modifies a
buffer to explicitly mark it as dirty, rather than depending upon
LockBuffer() to do it. Does this sound reasonable, provided I find and
catch all the places that depend upon this behavior? (i.e. and change
them to explicitly mark the buffer as dirty)
-Neil
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
