Stats improvement for Uncompressed Chunks

[shhnwz]

During the compression autovacuum use to be disabled for uncompressed chunk and enable after decompression. This leads to postgres maintainence issue. Let's not disable autovacuum for uncompressed chunk anymore. Let postgres take care of the stats in its natural way.

Fixes #3376 #4578 #4156

[codecov]

Codecov Report

Merging #5118 (66e4bdf) into main (5c07a57) will decrease coverage by 0.03%.
The diff coverage is 100.00%.

❗ Current head 66e4bdf differs from pull request most recent head 6da5da4. Consider uploading reports for the commit 6da5da4 to get more accurate results

@@            Coverage Diff             @@
##             main    #5118      +/-   ##
==========================================
- Coverage   90.70%   90.67%   -0.03%     
==========================================
  Files         228      228              
  Lines       53106    52981     -125     
==========================================
- Hits        48168    48040     -128     
- Misses       4938     4941       +3     

Impacted Files	Coverage Δ
src/cross_module_fn.c	67.91% <ø> (+1.07%)	⬆️
src/planner/planner.c	95.98% <ø> (+0.09%)	⬆️
tsl/src/compression/compression.c	96.11% <ø> (+0.28%)	⬆️
tsl/src/compression/compression.h	0.00% <ø> (ø)
tsl/src/init.c	96.29% <ø> (ø)
src/process_utility.c	94.43% <100.00%> (-0.10%)	⬇️
tsl/src/compression/api.c	95.60% <100.00%> (-0.22%)	⬇️

... and 4 files with indirect coverage changes

📣 We’re building smart automated test selection to slash your CI/CD build times. Learn more

[akuzm]

The issue also says:

we should instead use the get_relation_stats_hook to handle compressed chunk stats.

Do we have to change it in this PR as well?

[timescale-automation]

Automated backport to 2.10.x not done: cherry-pick failed.

Git status

HEAD detached at origin/2.10.x
You are currently cherry-picking commit 699fcf48.
  (fix conflicts and run "git cherry-pick --continue")
  (use "git cherry-pick --skip" to skip this patch)
  (use "git cherry-pick --abort" to cancel the cherry-pick operation)

Changes to be committed:
	modified:   .github/gh_matrix_builder.py
	modified:   .github/workflows/windows-build-and-test.yaml
	modified:   CHANGELOG.md
	modified:   sql/size_utils.sql
	modified:   src/cross_module_fn.c
	modified:   src/cross_module_fn.h
	modified:   src/planner/planner.c
	modified:   src/process_utility.c
	modified:   tsl/src/compression/api.c
	modified:   tsl/src/compression/compression.h
	modified:   tsl/src/init.c
	modified:   tsl/test/expected/chunk_merge.out
	modified:   tsl/test/expected/telemetry_stats-12.out
	modified:   tsl/test/expected/telemetry_stats-13.out
	modified:   tsl/test/expected/telemetry_stats-14.out
	modified:   tsl/test/expected/telemetry_stats-15.out
	modified:   tsl/test/expected/transparent_decompression-12.out
	modified:   tsl/test/expected/transparent_decompression-14.out
	modified:   tsl/test/expected/transparent_decompression-15.out
	modified:   tsl/test/isolation/expected/compression_chunk_race.out
	modified:   tsl/test/shared/expected/extension.out
	modified:   tsl/test/shared/expected/ordered_append_join-12.out
	modified:   tsl/test/shared/expected/ordered_append_join-13.out
	modified:   tsl/test/shared/expected/ordered_append_join-14.out
	modified:   tsl/test/shared/expected/ordered_append_join-15.out
	modified:   tsl/test/shared/expected/transparent_decompress_chunk-12.out
	modified:   tsl/test/shared/expected/transparent_decompress_chunk-13.out
	modified:   tsl/test/shared/expected/transparent_decompress_chunk-14.out
	modified:   tsl/test/shared/expected/transparent_decompress_chunk-15.out
	modified:   tsl/test/sql/chunk_merge.sql
	modified:   tsl/test/sql/compression.sql

Unmerged paths:
  (use "git add <file>..." to mark resolution)
	both modified:   sql/updates/reverse-dev.sql
	both modified:   tsl/src/compression/compression.c
	both modified:   tsl/test/expected/compression.out
	both modified:   tsl/test/expected/transparent_decompression-13.out

Job log