\set SHOW_CONTEXT never
SET client_min_messages TO WARNING;
CREATE EXTENSION IF NOT EXISTS citus;
CREATE EXTENSION IF NOT EXISTS citus_columnar;
CREATE EXTENSION IF NOT EXISTS timeseries CASCADE;
CREATE TABLE compression_test_measurements (
  metric_name text,
  metric_value numeric,
  metric_time timestamptz NOT NULL
) PARTITION BY RANGE (metric_time);
SELECT enable_ts_table('compression_test_measurements');
 enable_ts_table 
-----------------
 
(1 row)

SELECT COUNT(*) > 10 AS has_partitions FROM ts_part_info WHERE table_id='compression_test_measurements'::regclass;
 has_partitions 
----------------
 t
(1 row)

SELECT COUNT(*) > 0 AS "compressed?" FROM ts_part_info WHERE table_id='compression_test_measurements'::regclass AND access_method = 'columnar';
 compressed? 
-------------
 f
(1 row)

SELECT apply_compression_policy('compression_test_measurements', '1 day');
 apply_compression_policy 
--------------------------
 
(1 row)

SELECT COUNT(*) > 0 AS "compressed?" FROM ts_part_info WHERE table_id='compression_test_measurements'::regclass AND access_method = 'columnar';
 compressed? 
-------------
 t
(1 row)