First compress is very long

Hi! TimescaleDB version 2.14.2, PostgreSQL version 15.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-16), 64-bit

I faced with situation when first time add compression policy for hypertable (all the chunks are compressed except three last ones): compression applied to two chunks how expected but time of compression were 2 hours instead of 6 minutes.

What could be the problem?

Hey @LuxCore , thanks for reporting.
Have you checked if all chunks have similar sizes?

Are you maybe doing backfills or still inserting data on the chunks?

Hi @jonatasdp !
All the chunks have similar size.

No. I tested compression on test server in our company which has no users except me :slight_smile:

I noticed yet that if only one any chunk must be compressed then the compression worked as expected.
But two prelast uncompressed chunks were compressed for a long time.

Can you bring it as an issue on GitHub? because if we can make it reproducible we can probably fix it too! :smiley:

Before creating an issue, I want to check again this when the admins deploy the backup on the test server because the problem does not reappear.

@jonatasdp, Sorry for inconvenience, but unfortunately I cannot to reproduce this issue. If this will happen again then I will create the issue.

Hi Denis, no problem at all!

You’re so prolific on helping us always :raised_hands:

Thank you very much!

1 Like