| 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: | Whole Thread | Raw Message | 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 |
| 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 |