Re: Reduce the size of PageFreeSpaceInfo on 64bit platform - Mailing list pgsql-patches

From ITAGAKI Takahiro
Subject Re: Reduce the size of PageFreeSpaceInfo on 64bit platform
Date
Msg-id 20070813131016.6A3E.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
Whole thread Raw
In response to Re: Reduce the size of PageFreeSpaceInfo on 64bit platform  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: Reduce the size of PageFreeSpaceInfo on 64bit platform
Re: Reduce the size of PageFreeSpaceInfo on 64bit platform
List pgsql-patches
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

pgsql-patches by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: Re: Reduce the size of PageFreeSpaceInfo on 64bit platform
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Function structure in formatting.c