I wrote:

> I'll rewrite my patch to use
> FSMPageData in both places so that users can always estimate the memory
> to 6 bytes per page.

Here is a revised patch to reduce memory usage during VACUUM,
using FSMPageData (6 byte) instead of PageFreeSpaceInfo (8 or 16 bytes).
The keepable pages with freespace will extended to 21GB from 8GB with
16MB of default maintenance_work_mem.

ITAGAKI Takahiro
NTT Open Source Software Center

Attachment: remove_PageFreeSpaceInfo.patch
Description: Binary data

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not

Reply via email to