This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold
--------------------------------------------------------------------------- ITAGAKI Takahiro wrote: > 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 > [ Attachment, skipping... ] > > ---------------------------(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 -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster