Re: Improve compression speeds in pg_lzcompress.c
From:
John R Pierce <pierce(at)hogranch(dot)com>
To:
pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Improve compression speeds in pg_lzcompress.c
Date:
2013-01-07 10:21:26
Message-ID:
50EAA1A6.1050307@hogranch.com (view raw or flat )
Thread:
2013-01-07 07:29:58 from Takeshi Yamamuro <yamamuro(dot)takeshi(at)lab(dot)ntt(dot)co(dot)jp>
2013-01-07 09:10:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-07 09:19:59 from John R Pierce <pierce(at)hogranch(dot)com>
2013-01-07 09:57:58 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-07 10:05:24 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-01-07 10:21:26 from John R Pierce <pierce(at)hogranch(dot)com>
2013-01-07 10:39:22 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-01-07 13:36:33 from Greg Stark <stark(at)mit(dot)edu>
2013-01-07 13:48:06 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-07 13:57:41 from "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
2013-01-08 09:19:13 from Takeshi Yamamuro <yamamuro(dot)takeshi(at)lab(dot)ntt(dot)co(dot)jp>
2013-01-08 11:24:32 from Hannu Krosing <hannu(at)krosing(dot)net>
2013-01-07 13:52:09 from "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
2013-01-08 09:08:13 from Takeshi Yamamuro <yamamuro(dot)takeshi(at)lab(dot)ntt(dot)co(dot)jp>
2013-01-07 14:03:21 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-01-07 16:16:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-07 20:18:57 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2013-01-07 20:41:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-07 21:36:25 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2013-01-07 21:07:51 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-07 21:19:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-07 21:44:50 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-01-08 09:04:24 from Takeshi Yamamuro <yamamuro(dot)takeshi(at)lab(dot)ntt(dot)co(dot)jp>
2013-01-08 13:20:42 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-08 14:51:06 from Claudio Freire <klaussfreire(at)gmail(dot)com>
2013-01-08 22:14:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-09 07:56:12 from Benedikt Grundmann <bgrundmann(at)janestreet(dot)com>
2013-01-07 22:00:39 from Robert Haas <robertmhaas(at)gmail(dot)com>
Lists:
pgsql-hackers
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.
In response to
Responses
pgsql-hackers by date
Next :From: Andres FreundDate: 2013-01-07 10:39:22Subject : Re: Improve compression speeds in pg_lzcompress.cPrevious :From : Andres FreundDate : 2013-01-07 10:05:24Subject : Re: Improve compression speeds in pg_lzcompress.c
