On Wed, Jun 8, 2011 at 11:30 PM, Merlin Moncure <mmonc...@gmail.com> wrote: > The heap pages that have been marked this way may or may not have to > be off limits from the backend other than the one that did the > marking, and if they have to be off limits logically, there may be no > realistic path to make them so.
After some more thought, plus a bit of off-list coaching from Haas, I see now the whole approach is basically a non-starter due to the above. Heap pages *are* off limits, because once deferred they can't be scribbled on and committed by other transactions -- that would violate the 'wal before data' rule. To make it 'work', you'd have to implement shared memory machinery to do cooperative flushing as suggested upthread (complex, nasty) or simply block on deferred pages...which would be a deadlock factory. Oh well. :( merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
