edit-icon download-icon

How to enable column-store and compression in HybridDB for PostgreSQL?

Last Updated: Dec 28, 2017

Row-store with no compression is used by default when you create a table in HybridDB for PostgreSQL. To enable column-store and compression, you must specify the column-store and compression options when creating the table. For example, you can add the following statement to the tabulation statements to enable the two features.


In general, we recommend that you enable column-store and compression, especially when you have a lot of complicated queries to the table, or when you want to reduce the storage cost.

Note: HybridDB for PostgreSQL currently only supports the zlib and RLE_TYPE compression algorithms. If you specify to use quicklz, HybridDB for PostgreSQL automatically converts the algorithm to zlib.

Thank you! We've received your feedback.