Re: pg_upgrade: How to deal with toast - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: pg_upgrade: How to deal with toast
Date
Msg-id 492500C6.2080602@enterprisedb.com
Whole thread Raw
In response to pg_upgrade: How to deal with toast  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Responses Re: pg_upgrade: How to deal with toast  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
List pgsql-hackers
Zdenek Kotala wrote:
> 2) data type is unknown
> 
> Unfortunately, in low function is no clue what data type is really 
> stored in a chunks.

Do we need to know? We haven't changed the on-disk format of any data 
types between 8.3 and 8.4, have we?

The other idea that was suggested earlier is to retoast all toast datums 
referenced from the heap page, when the heap page is read in. We know 
the data types at that point. That generates a lot more random I/O on 
the first access to the unconverted heap page, but I think it would be ok.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: HEAD build failure on win32 mingw
Next
From: Tom Lane
Date:
Subject: Re: HEAD build failure on win32 mingw