Re: Index padding optimization - Mailing list pgsql-patches

From ITAGAKI Takahiro
Subject Re: Index padding optimization
Date
Msg-id 20060117095858.4EC0.ITAGAKI.TAKAHIRO@lab.ntt.co.jp
Whole thread Raw
In response to Re: Index padding optimization  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> This seems extremely invasive for a relatively small gain :-(
> The example you cite of an int4 index on a MAXALIGN-8 machine is
> by far the best case, and in many cases there wouldn't be anything
> bought by the extra complexity.

I also think that it has small advantage without another compression method.
But if we tries to compress index keys using prefix compression or so,
we might need to put tuples with no/small alignment.

I would like to propose it again when I find another method which will work
well with this patch.

---
ITAGAKI Takahiro
NTT Cyber Space Laboratories



pgsql-patches by date:

Previous
From: "Benjamin Wragg"
Date:
Subject: ISBN-13 support
Next
From: Neil Conway
Date:
Subject: Re: patch to create system view that lists cursors