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

From Zdenek Kotala
Subject Re: pg_upgrade: How to deal with toast
Date
Msg-id 49254BD9.1050001@sun.com
Whole thread Raw
In response to Re: pg_upgrade: How to deal with toast  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List 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 by date:

Previous
From: Grzegorz Jaskiewicz
Date:
Subject: Re: Updated posix fadvise patch v19
Next
From: Magnus Hagander
Date:
Subject: Autoconf, libpq and replacement function