RE: Speedup of relation deletes during recovery - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject RE: Speedup of relation deletes during recovery
Date
Msg-id 0A3221C70F24FB45833433255569204D1F944AD7@G01JPEXMBYT05
Whole thread Raw
In response to Re: Speedup of relation deletes during recovery  (Fujii Masao <masao.fujii@gmail.com>)
List 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 by date:

Previous
From: Amit Langote
Date:
Subject: Re: [HACKERS] Runtime Partition Pruning
Next
From: Teodor Sigaev
Date:
Subject: Re: WIP: Covering + unique indexes.