By using AWS re:Post, you agree to the Terms of Use
/LZ4 compression on RDS Postgres 14/

LZ4 compression on RDS Postgres 14

3 Answers
Accepted Answer

Verified lz4 is available.

  • created RDS for PostgreSQL 14.1 instance
  • SHOW default_toast_compression; returned pglz
  • INSERT INTO TESTLZ4 VALUES (repeat('123456789', 1000));
  • SELECT pg_column_compression(COL_1) FROM TESTLZ4; retured 'lz4'
  • SET default_toast_compression TO lz4;
  • SHOW default_toast_compression; returned lz4
answered 3 months ago

Amazon Relational Database Service (Amazon RDS) for PostgreSQL does not have database wide compression. For variable length datatypes(text, varchar), RDS for PostgreSQL has TOAST (The oversized attribute storage technique) storage. TOAST by default uses pglz compression. Now with RDS for PostgreSQL 14 you can also use lz4 compression. The transparent compression handled by TOAST, and the option for compression in CREATE/ALTER TABLE are the extent of compression options in RDS for PostgreSQL.

answered 3 months ago
  • Thank you, but I'm aware of all that. I'm specifically asking whether the version of Postgres 14 that's running on RDS was compiled with LZ4 support, which is why I linked to the Postgres doc page that explains this.


Most of this type of information is also available via the pg_config view. -- on RDS Postgres 14.1 you can see --with-lz4 in the configure info.

postgres=> select name,setting from pg_config where name ilike 'configure';
   name    |                                                                                                                                                                                                                                                                               setting                                                                                          
 CONFIGURE |  '--prefix=/rdsdbbin/postgres-14.1.R1' '--with-openssl' '--with-perl' '--with-tcl' '--with-ossp-uuid' '--with-libxml' '--with-pam' '--with-ldap' '--with-krb-srvnam=whatever' '--with-gssapi' '--with-libraries=/rdsdbbin/postgres-14.1.R1/lib' '--with-includes=/rdsdbbin/postgres-14.1.R1/include' '--enable-debug' '--with-llvm' 'LLVM_CONFIG=/build/llvm/bin/llvm-config' '--with-icu' 'ICU_CFLAGS=-I/rdsdbbin/postgres-14.1.R1/include -DU_STATIC_IMPLEMENTATION' '--with-lz4' 'ICU_LIBS=-L/rdsdbbin/postgres-14.1.R1/lib -licui18n -licuuc -licudata -lstdc++'
(1 row)
answered 3 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions