RE: Speedup of relation deletes during recovery

Поиск
Список
Период
Сортировка
От Tsunakawa, Takayuki
Тема RE: Speedup of relation deletes during recovery
Дата
Msg-id 0A3221C70F24FB45833433255569204D1F944AD7@G01JPEXMBYT05
обсуждение исходный текст
Ответ на Re: Speedup of relation deletes during recovery  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
From: Fujii Masao [mailto:masao.fujii@gmail.com]
> Yeah, it's worth working on this problem. To decrease the number of scans
> of
> shared_buffers, you would need to change the order of truncations of files
> and
> WAL logging. In RelationTruncate(), currently WAL is logged after FSM and
> VM
> are truncated. IOW, with the patch, FSM and VM would need to be truncated
> after
> WAL logging. You would need to check whether this reordering is valid.

Sure, thank you for advice.

Takayuki Tsunakawa


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: [HACKERS] Runtime Partition Pruning
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: WIP: Covering + unique indexes.