Cannot enable chunk skipping after upgrading to 2.17.1

TimescaleDB and PostgreSQL
1

Hi,

I upgraded Timescale from 2.16.0-dev to 2.17.1 and have been trying to use chunk skipping on a compressed hypertable.

I do select enable_chunk_skipping ('hypertable_name', 'column_to_skip') but get this error:

chunk skipping functionality disabled, enable it by first setting timescaledb.enable_chunk_skipping to on

I don’t see anything in the documentation on this. Is this a parameter in the postgresql.conf file or somewhere else?

2

Hello @kunjmehta , if your user is admin, you can enable it directly from the session, but for all the system:

alter system set timescaledb.enable_chunk_skipping to on;

Or just make it in the actual session:

set timescaledb.enable_chunk_skipping to on;

You can also put it on postgreql.conf in case you want to persist it for all databases.