Re: Why copy_relation_data only use wal whenWALarchivingis enabled
От
Jacky Leng
Тема
Re: Why copy_relation_data only use wal whenWALarchivingis enabled
Дата
Msg-id
ff6cqj$26ie$1@news.hub.org
Список
Дерево обсуждения
Re: Why copy_relation_data only use wal when WALarchiving is enabled "Jacky Leng" <lengjianquan@163.com>
> Heikki Linnakangas writes: > I tend to agree that truncating the file, and extending the fsync > request mechanism to actually delete it after the next checkpoint, > is the most reasonable route to a fix. > How about just allowing to use wal even WAL archiving is disabled? It seems that recovery of "XLOG_HEAP_NEWPAGE" record will do the right thing for us, look at "heap_xlog_newpage": XLogReadBuffer with init=true will extend the block rightly and rebuild it rightly. Someone may say that it's not worth recording xlog for operations such as copy_relation_data, but these operations shouldn't happen frequently.
В списке pgsql-hackers по дате отправления
От: Jacky Leng
Дата:
От: Jacky Leng
Дата: