Re: pg_upgrade: How to deal with toast

Поиск
Список
Период
Сортировка
От Zdenek Kotala
Тема Re: pg_upgrade: How to deal with toast
Дата
Msg-id 49254BD9.1050001@sun.com
обсуждение исходный текст
Ответ на Re: pg_upgrade: How to deal with toast  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
Heikki Linnakangas napsal(a):

> It the new attribute is added to the end, the old tuples will be 
> compatible as is. If there's no null bitmap (or it's shorter than 
> expectd), attributes missing from a tuple are implicitly NULL. That's 
> how we support ALTER TABLE ADD COLUMN without rewriting all the data.
> 

Yeah, but better is to put int column before chunk data. It save space 
(alignment). I prefer to put attno as a third column.
    Zdenek


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

Предыдущее
От: Grzegorz Jaskiewicz
Дата:
Сообщение: Re: Updated posix fadvise patch v19
Следующее
От: Magnus Hagander
Дата:
Сообщение: Autoconf, libpq and replacement function