Re: Questions on extending a relation - Mailing list pgsql-hackers

From Qingqing Zhou
Subject Re: Questions on extending a relation
Date
Msg-id d9qdae$2g98$1@news.hub.org
Whole thread Raw
In response to Questions on extending a relation  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
List pgsql-hackers
"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




pgsql-hackers by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Implementing SQL/PSM for PG 8.2
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Problem with dblink regression test