Re: Index padding optimization

From: ITAGAKI Takahiro <itagaki(dot)takahiro(at)lab(dot)ntt(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Index padding optimization
Date: 2006-01-17 01:17:04
Message-ID: 20060117095858.4EC0.ITAGAKI.TAKAHIRO@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2006-01-17 06:28:10 Re: patch to create system view that lists cursors
Previous Message Benjamin Wragg 2006-01-17 00:58:24 ISBN-13 support