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.

  1. with (APPENDONLY=true, ORIENTATION=column, COMPRESSTYPE=zlib, COMPRESSLEVEL=5, BLOCKSIZE=1048576, OIDS=false)

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.