Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: remove_PageFreeSpaceInfo.patch
Description: application/octet-stream (15.5 KB)

In response to

Responses

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group