MySQL Forums
Forum List  »  Partitioning

partitioning and compression efficiency
Posted by: George Develekos
Date: September 20, 2018 07:22AM

Hello,

When I compress a table that is partitioned by linear hash, I get a substantial benefit, size ratio is 3.63. When I alter the table to partition it by key (which is what we prefer in this case) the benefit drops to a negligible ratio 1.17.

Is there an explanation for this?

Thanks,
George

Options: ReplyQuote


Subject
Views
Written By
Posted
partitioning and compression efficiency
72
September 20, 2018 07:22AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.