On 2013-01-07 02:21:26 -0800, John R Pierce wrote:
> On 1/7/2013 2:05 AM, Andres Freund wrote:
> >I think there should be enough bits available in the toast pointer to
> >indicate the type of compression. I seem to remember somebody even
> >posting a patch to that effect?
> >I agree that it's probably too late in the 9.3 cycle to start with this.
>
> so an upgraded database would have old toasted values in the old compression
> format, and new toasted values in the new format in an existing table?
> that's kind of ugly.

Well, ISTM thats just life. What you prefer? Converting all toast values
during pg_upgrade kinda goes against the aim of quick upgrades.

Greetings,

Andres Freund

--
 Andres Freund	                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

• Re: Improve compression speeds in pg_lzcompress.c at 2013-01-07 10:21:26 from John R Pierce

pgsql-hackers by date

Next:	From: Peter Eisentraut	Date: 2013-01-07 12:14:58
	Subject: psql \l to accept patterns
Previous:	From: John R Pierce	Date: 2013-01-07 10:21:26
	Subject: Re: Improve compression speeds in pg_lzcompress.c