MIME-Version: 1.0
From: =?UTF-8?Q?Saulo_Jos=C3=A9_Benvenutti?= <saulojb@gmail.com>
Date: Sun, 19 Apr 2026 10:46:30 -0300
Message-ID: <CAFOk60K4J=Z7V-4jkVTMa4AD+4Yd6vMeUYYV+VS+wvYMuL+COw@mail.gmail.com>
Subject: =?UTF-8?Q?ANN=3A_storage=5Fengine_1=2E0=2E7_=E2=80=93_columnar_=2B_row=2Dcompres?=
	=?UTF-8?Q?sed_Table_Access_Methods_for_PostgreSQL_16=2D18?=
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000007ec8c2064fd0690b"
Archived-At: <https://www.postgresql.org/message-id/CAFOk60K4J%3DZ7V-4jkVTMa4AD%2B4Yd6vMeUYYV%2BVS%2BwvYMuL%2BCOw%40mail.gmail.com>
Precedence: bulk

--0000000000007ec8c2064fd0690b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

I'd like to announce storage_engine 1.0.7, a PostgreSQL extension
providing two high-performance Table Access Methods:

- colcompress: column-oriented compressed storage with vectorized
  execution, chunk-level min/max pruning, parallel scan, and
  MergeTree-like ordering.

- rowcompress: row-oriented batch-compressed storage with parallel
  scan, DELETE/UPDATE support via deleted bitmasks, and LRU
  decompression cache.

Highlights vs heap (1M rows, PostgreSQL 18, serial):
  - Aggregations: up to 10x faster
  - Compressed size: 3=E2=80=935x smaller
  - GIN/JSONB queries: fully supported

Compatible with PostgreSQL 16, 17, and 18.

GitHub:  https://github.com/saulojb/storage_engine
PGXN:    https://pgxn.org/dist/storage_engine/
Article: https://dev.to/...

Feedback and contributions welcome.

Regards,
Saulo J. Benvenutti
--=20
       Saulo Jos=C3=A9 Benvenutti
Analista Programador Delphi/C#

--0000000000007ec8c2064fd0690b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><br clear=3D"all"></div><div>Hi,<br><br>I&#39;d like =
to announce storage_engine 1.0.7, a PostgreSQL extension<br>providing two h=
igh-performance Table Access Methods:<br><br>- colcompress: column-oriented=
 compressed storage with vectorized<br>=C2=A0 execution, chunk-level min/ma=
x pruning, parallel scan, and<br>=C2=A0 MergeTree-like ordering.<br><br>- r=
owcompress: row-oriented batch-compressed storage with parallel<br>=C2=A0 s=
can, DELETE/UPDATE support via deleted bitmasks, and LRU<br>=C2=A0 decompre=
ssion cache.<br><br>Highlights vs heap (1M rows, PostgreSQL 18, serial):<br=
>=C2=A0 - Aggregations: up to 10x faster<br>=C2=A0 - Compressed size: 3=E2=
=80=935x smaller<br>=C2=A0 - GIN/JSONB queries: fully supported<br><br>Comp=
atible with PostgreSQL 16, 17, and 18.<br><br>GitHub: =C2=A0<a href=3D"http=
s://github.com/saulojb/storage_engine">https://github.com/saulojb/storage_e=
ngine</a><br>PGXN: =C2=A0 =C2=A0<a href=3D"https://pgxn.org/dist/storage_en=
gine/">https://pgxn.org/dist/storage_engine/</a><br>Article: <a href=3D"htt=
ps://dev.to/.">https://dev.to/.</a>..<br><br>Feedback and contributions wel=
come.<br><br>Regards,<br>Saulo J. Benvenutti</div><span class=3D"gmail_sign=
ature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature" data=
-smartmail=3D"gmail_signature">=C2=A0 =C2=A0 =C2=A0=C2=A0 Saulo Jos=C3=A9 B=
envenutti<br>Analista Programador Delphi/C#</div></div>

--0000000000007ec8c2064fd0690b--