Re: Reduce the size of PageFreeSpaceInfo on 64bit platform

From: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: Reduce the size of PageFreeSpaceInfo on 64bit platform
Date: 2007-08-13 04:19:01
Message-ID: 20070813131016.6A3E.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
remove_PageFreeSpaceInfo.patch application/octet-stream 15.5 KB

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Heikki Linnakangas 2007-08-13 12:32:42 Re: ON DELETE SET NULL clauses do error when more than two columns are referenced to one table
Previous Message ITAGAKI Takahiro 2007-08-13 01:40:31 Re: Reduce the size of PageFreeSpaceInfo on 64bit platform