I know in SQL that we can compress the text field as follows:
< Code> make table tablename (field name character (255) with compression);
I want to know how to get text compression in postgres.
Compression is enabled by default for all string types, to let you know the database Do not need to Check for manual
- Plain stops compression or out-of-line storage; Apart from this it disables the use of single-byte headers for varlena types. This is the only possible strategy for non-TOAST-enabled data type columns.
- Allows both extended compression and out-of-line storage. This is the default for most TOAST-enabled data types. Compression attempts will be first, then out-of-the-line storage if the row is still very large.
- External permissions - File storage but no compression will use the external to operate the substrings on most text and baittia columns (fines of greater storage space) because these functions are out-of-line values It is optimized to get only the necessary parts of it when it is not compressed.
- MAIN compression allows but does not have out-of-the-line storage (in fact, out-of-line storage will be used for such columns, but only as a last resort There is no other way to shorten enough to fit a line on a page.)
Comments
Post a Comment