Re: Why copy_relation_data only use wal when WAL archiving is enabled - Mailing list pgsql-hackers

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 relation file.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com