Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Compression Troubleshooting: Inefficient compress_chunk_time_interval configuration #3911

Open
philkra opened this issue Mar 10, 2025 · 2 comments · May be fixed by #3937
Open

Compression Troubleshooting: Inefficient compress_chunk_time_interval configuration #3911

philkra opened this issue Mar 10, 2025 · 2 comments · May be fixed by #3937
Assignees

Comments

@philkra
Copy link
Contributor

philkra commented Mar 10, 2025

Please add the following part to the troubleshooting page for compression: https://docs.timescale.com/use-timescale/latest/compression/troubleshooting

Follow up of timescale/timescaledb#7786


Title: Inefficient compress_chunk_time_interval configuration
Text:

When compress_chunk_time_interval is configured but compress_orderby does not have the primary dimension as the first column, chunk merging will be less efficient as chunks have to be decompressed to be merged. Please ensure the first column in compress_orderby is the primary dimension of the chunk.

TimescaleDB will show you the following hint:

compress_chunk_time_interval configured and primary dimension not first column in compress_orderby. 
consider setting "<column name>" as first compress_orderby column

Thank you

@atovpeko atovpeko self-assigned this Mar 14, 2025
@atovpeko
Copy link
Contributor

@philkra thank you very much for thinking about adding this to docs :-) Can we add a quick explanation what to do when this hint is encountered? Even if it's completely obvious, the troubleshooting page should provide a solution.

@atovpeko atovpeko linked a pull request Mar 17, 2025 that will close this issue
@philkra
Copy link
Contributor Author

philkra commented Mar 27, 2025

@atovpeko thank you for your patience. I added a sentence

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants