Re: [HACKERS] Why copy_relation_data only use wal when WAL archiving is enabled

2007-10-17 Thread Simon Riggs
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

Re: [HACKERS] Why copy_relation_data only use wal when WAL archiving is enabled

2007-10-17 Thread Jacky Leng
> 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

Re: [HACKERS] Why copy_relation_data only use wal when WAL archiving is enabled

2007-10-16 Thread Heikki Linnakangas
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