What does Page Layout version mean? (Was: Re: Reducing NUMERIC size for 8.3)

Поиск
Список
Период
Сортировка
От Zdenek Kotala
Тема What does Page Layout version mean? (Was: Re: Reducing NUMERIC size for 8.3)
Дата
Msg-id 46779CA3.2050601@sun.com
обсуждение исходный текст
Ответ на Reducing NUMERIC size for 8.3  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: What does Page Layout version mean? (Was: Re: Reducing NUMERIC size for 8.3)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Simon Riggs wrote:

> 
> The objections to applying this patch originally were:
> 1. it changes on-disk format (we've done this, so argument is void)

I'm little bit confused when we introduce new page layout version? I 
expect that new version become with changes with pageheader, tuple 
header or data encoding (varlen/TOAST ...). But in case when there is 
new data type internal implementation, there was not reason to update 
version (see inet/cidr between 8.1 -> 8.2). Can me somebody clarify this?


However, In upgrade point of view. It will be necessary to keep 
information which postgreSQL version creates page to correctly track 
data type implementation (or special structure). Information in 
pg_control file and PG_VERSION files are unusable for upgrade purpose.
    Zdenek


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

Предыдущее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: PostgreSQL Developer needed in San Diego
Следующее
От: Timasmith
Дата:
Сообщение: to partition or not to partition that is the question