message: increased compression_ratio test size to get a more accurate ratio
diff: @@ -13,7 +13,7 @@ PRAGMA force_compression='bitpacking'
  # Compress value size: 64(bits) + 64(frame-of-reference) + (1024 * 1) = 1152
  # Ratio: 65536 / 1152 = 56.88
  statement ok
  -CREATE TABLE test_bitpacked AS SELECT (2000 + i%2)::INT64 AS i FROM range(0, 2500000) tbl(i);
  +CREATE TABLE test_bitpacked AS SELECT (2000 + i%2)::INT64 AS i FROM range(0, 10000000) tbl(i);
  statement ok
  checkpoint
  @@ -22,15 +22,20 @@ statement ok
  PRAGMA force_compression='uncompressed'
  statement ok
  -CREATE TABLE test_uncompressed AS SELECT (2000 + i%2)::INT64 AS i FROM range(0, 2500000) tbl(i);
  +CREATE TABLE test_uncompressed AS SELECT (2000 + i%2)::INT64 AS i FROM range(0, 10000000) tbl(i);
  statement ok
  checkpoint
  +query I
  +SELECT compression FROM pragma_storage_info('test_bitpacked') WHERE segment_type != 'VALIDITY' AND compression != 'BitPacking';
  +----
  +
  +
  # This query keeps a pretty wide margin in compression ratio on purpose to account for possible changes that
  # influence compression ratio.
  query II
  -select (uncompressed::FLOAT / bitpacked::FLOAT) > 38, (uncompressed::FLOAT / bitpacked::FLOAT) < 57 FROM (
  +select (uncompressed::FLOAT / bitpacked::FLOAT) > 45, (uncompressed::FLOAT / bitpacked::FLOAT) < 57 FROM (
  select
  (select count(distinct block_id) from pragma_storage_info('test_bitpacked') where segment_type not in('VARCHAR', 'VALIDITY')) as bitpacked,
  (select count(distinct block_id) from pragma_storage_info('test_uncompressed') where segment_type not in('VARCHAR', 'VALIDITY')) as uncompressed
  