Performance penalty of visibility info in indexes?

From: Jim Nasby <decibel(at)decibel(dot)org>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Performance penalty of visibility info in indexes?
Date: 2007-02-02 05:57:41
Message-ID: 9835AE6B-7A50-480A-99C5-F325DDB12BBC@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Has anyone actually measured the performance overhead of storing
visibility info in indexes? I know the space overhead sounds
daunting, but even if it doubled the size of the index in many cases
that'd still be a huge win over having to scan the heap as well as
the index (esp. for things like count(*)). There would also be
overhead from having to update the old index tuple, but for the case
of updates you're likely to need that page for the new index tuple
anyway.

I know this wouldn't work for all cases, but ISTM there are many
cases where it would be a win.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Nasby 2007-02-02 06:03:09 Re: Estimation error in n_dead_tuples
Previous Message Bruce Momjian 2007-02-02 05:43:04 Re: column ordering, was Re: [PATCHES] Enums patch v2