Re: Dept of ugly hacks: eliminating padding space in system indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Dept of ugly hacks: eliminating padding space in system indexes
Date: 2008-07-01 14:00:16
Message-ID: 3052.1214920816@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> writes:
> Tom Lane napsal(a):
>> Cutting a third off the size of a system index has got to be worth
>> something, but is it worth a hack as ugly as this one?

> The problem what I see there is how to fit with in-place-upgrade. Catalog should
> be generate from scratch, but if somebody uses name in regular table it invokes
> request for reindex.

Actually, an existing index stored as "name" would continue to work
fine, so I think this could be worked around. But in any case name is
deprecated for user use, so anyone who suffers a reindex has only
themselves to blame.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gurjeet Singh 2008-07-01 14:07:03 Re: Confusing message in log file
Previous Message Tom Lane 2008-07-01 13:53:05 Re: WIP patch: reducing overhead for repeat de-TOASTing