From: | Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Dept of ugly hacks: eliminating padding space in system indexes |
Date: | 2008-07-01 14:32:06 |
Message-ID: | 486A3FE6.5090602@sun.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane napsal(a):
> 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.
Yes, it is deprecated by you know a user. Give him a loaded shot-gun and he
start play a golf :-).
However, reindex is acceptable penalty for user who uses deprecated things.
Zdenek
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2008-07-01 14:36:50 | Re: A new take on the foot-gun meme |
Previous Message | Zdenek Kotala | 2008-07-01 14:26:41 | Re: PATCH: CITEXT 2.0 |