"Tom Lane" <tgl@sss.pgh.pa.us> writes
>
> Yes. That's intentional --- otherwise they'd all block each other.
>
So if I saw the last two pages on a disk relation are half full, that's
nothing wrong?
>
> Why wouldn't we replay xlog? Note in particular that the bgwriter is
> not allowed to push page B to disk until the xlog entry describing the
> index change has been flushed to disk. Since that will come after the
> xlog entry about the heap change, both changes are necessarily on-disk
> in the xlog, and both will be remade during replay.
>
Yes, I made a mistake. We reply xlog in any ways (no matter the transaction
commits or not).
Thanks,
Qingqing