From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: kg.postgresql@olympiakos.com
Subject: BUG #17513: recompressing already-compressed data via VACUUM FULL or CLUSTER does not work
Date: Wed, 08 Jun 2022 19:41:22 +0000
Message-ID: <17513-fe70a8ef15de3e76@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17513
Logged by: Kiriakos Georgiou
Email address: kg.postgresql@olympiakos.com
PostgreSQL version: 14.3
Operating system: Linux
Description:
Per
https://www.postgresql.org/message-id/E1lNKw9-0008DT-1L%40gemulon.postgresql.org
and https://www.enterprisedb.com/blog/configurable-lz4-toast-compression
if you change a column's compression algorithm and run VACUUM FULL or
CLUSTER, the data will be recompressed with the new compression algorithm.
This is does not work for 14.2 and 14.3 (the only two versions I tested).
TEST CASE:
I run the small test from Dilip Kumar's post (2nd link above) and after the
VACUUM FULL I get this, which is not the desired outcome (both should be
pglz):
test=> SELECT pg_column_compression(f1) FROM cmdata;
pg_column_compression
-----------------------
lz4
pglz
(2 rows)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, kg.postgresql@olympiakos.com
Subject: Re: BUG #17513: recompressing already-compressed data via VACUUM FULL or CLUSTER does not work
In-Reply-To: <17513-fe70a8ef15de3e76@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox