Recompresses a compressed chunk that had more data inserted after compression.
recompress_chunk(chunk REGCLASS,if_not_compressed BOOLEAN = false)
You can also recompress chunks by
running the job associated with your compression policy.
recompress_chunk gives you more fine-grained control by
allowing you to target a specific chunk.
recompress_chunk is implemented as an SQL procedure and not a function. Call the procedure with
CALL. Don't use a
recompress_chunk only works on chunks that have previously been compressed. To compress a chunk for the first time, use
|The chunk to be recompressed. Must include the schema, for example |
Recompress the chunk
In TimescaleDB 2.6.0 and above,
recompress_chunk is implemented as a procedure.
Previously, it was implemented as a function. If you are upgrading to
TimescaleDB 2.6.0 or above, the
function could cause an error. For example, trying to run
recompress_chunk(i.show_chunks, true) FROM... gives the following error:
ERROR: recompress_chunk(regclass, boolean) is a procedure
To fix the error, use
CALL instead of
SELECT. You might also need to write a
procedure to replace the full functionality in your
SELECT statement. For
DO $$DECLARE chunk regclass;BEGINFOR chunk IN SELECT format('%I.%I', chunk_schema, chunk_name)::regclassFROM timescaledb_information.chunksWHERE is_compressed = trueLOOPRAISE NOTICE 'Recompressing %', chunk::text;CALL recompress_chunk(chunk, true);END LOOP;END$$;
Found an issue on this page?Report an issue!