[request] LZ4, Zstandard compression support

ImreSamu · April 14, 2023, 7:00am

Please add LZ4/ZSTD compression to the postgres Install- procedure:

now this is missing

--with-lz4
Build with LZ4 compression support.

--with-zstd
Build with Zstandard compression support.

as I see now:

github.com

neondatabase/neon/blob/b6c7c3290f795d918f726de2df0015bb4a3cd260/Dockerfile.compute-node#L27


      
          #########################################################################################
          #
          # Layer "pg-build"
          # Build Postgres from the neon postgres repository.
          #
          #########################################################################################
          FROM build-deps AS pg-build
          ARG PG_VERSION
          COPY vendor/postgres-${PG_VERSION} postgres
          RUN cd postgres && \
              ./configure CFLAGS='-O2 -g3' --enable-debug --with-openssl --with-uuid=ossp --with-icu \
              --with-libxml --with-libxslt && \
              make MAKELEVEL=0 -j $(getconf _NPROCESSORS_ONLN) -s install && \
              make MAKELEVEL=0 -j $(getconf _NPROCESSORS_ONLN) -s -C contrib/ install && \
              # Install headers
              make MAKELEVEL=0 -j $(getconf _NPROCESSORS_ONLN) -s -C src/include install && \
              make MAKELEVEL=0 -j $(getconf _NPROCESSORS_ONLN) -s -C src/interfaces/libpq install && \
              # Enable some of contrib extensions
              echo 'trusted = true' >> /usr/local/pgsql/share/extension/autoinc.control && \
              echo 'trusted = true' >> /usr/local/pgsql/share/extension/bloom.control && \
              echo 'trusted = true' >> /usr/local/pgsql/share/extension/earthdistance.control && \

imho : just add a --with-lz4 --with-zstd ( and install the liblz4-dev libzstd-dev it should work with pg14 with a warning …

test :

[neondb] # SET default_toast_compression=lz4;
ERROR:  22023: invalid value for parameter "default_toast_compression": "lz4"
HINT:  Available values: pglz.

[neondb] # select version();
                                              version                                              
---------------------------------------------------------------------------------------------------
 PostgreSQL 15.2 on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
(1 row)

// as a new user , I can’t add more links ; sorry …

ImreSamu · April 14, 2023, 7:03am