Re: Questions on extending a relation

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Questions on extending a relation
Date: 2005-06-28 02:38:06
Message-ID: d9qdae$2g98$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2005-06-28 02:58:22 Re: Problem with dblink regression test
Previous Message Christopher Browne 2005-06-28 02:20:38 Re: Implementing SQL/PSM for PG 8.2