Re: Improve compression speeds in pg_lzcompress.c - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Improve compression speeds in pg_lzcompress.c
Date
Msg-id 20130107103922.GB5301@awork2.anarazel.de
Whole thread Raw
In response to Re: Improve compression speeds in pg_lzcompress.c  (John R Pierce <pierce@hogranch.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: John R Pierce
Date:
Subject: Re: Improve compression speeds in pg_lzcompress.c
Next
From: Peter Eisentraut
Date:
Subject: psql \l to accept patterns