On Wed, 2007-10-17 at 17:18 +0800, Jacky Leng wrote:
> Second, suppose that no checkpoint has occured during the upper
> series--authough not quite possible;
That part is irrelevant. It's forced out to disk and doesn't need
recovery, with or without the checkpoint.
There's no hole that I can se
> Jacky Leng wrote:
>> If I run the database under non-archiving mode, and execute the following
>> command:
>> alter table t set tablespace tblspc1;
>> Isn't it possible that the "new t" cann't be recovered?
>
> No. At the end of copy_relation_data we call smgrimmedsync, which fsyncs
> the ne
Jacky Leng wrote:
> If I run the database under non-archiving mode, and execute the following
> command:
> alter table t set tablespace tblspc1;
> Isn't it possible that the "new t" cann't be recovered?
No. At the end of copy_relation_data we call smgrimmedsync, which fsyncs
the new relatio