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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Dept of ugly hacks: eliminating padding space in system indexes
Дата
Msg-id 3052.1214920816@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Dept of ugly hacks: eliminating padding space in system indexes  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Ответы Re: Dept of ugly hacks: eliminating padding space in system indexes  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Список pgsql-hackers
Zdenek Kotala <Zdenek.Kotala@Sun.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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: WIP patch: reducing overhead for repeat de-TOASTing
Следующее
От: "Gurjeet Singh"
Дата:
Сообщение: Re: Confusing message in log file