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. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center
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
match
