--- title: "Bringing transparent data encryption (TDE) to Postgres 18" publication: "Postgres Weekly" issue: 627 published_at: "2025-12-04" canonical_url: "https://postgresweekly.com/issues/627" --- Plus a list of upcoming Postgres events in 2026. | #โ€‹627 โ€” December 4, 2025 [Web Version](https://postgresweekly.com/issues/627) ๐Ÿ—“๏ธ Every now and then we do a roundup of upcoming Postgres events and 2026 is already shaping up to be a busy year โ€“ check it out at the end of the issue. __ _Your editor, Peter Cooper._ Together with [![Microsoft logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_280,h_60/e_make_transparent/co_white,e_outline:7/om9hjsmudy5lsvba59eb.png)](https://posetteconf.com/2026/cfp/) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/rgnw8r0j0wkkom96fzut.jpg)](https://www.depesz.com/2025/11/29/using-json-json-vs-jsonb-pglz-vs-lz4-key-optimization-parsing-speed/) [On the Efficient Storage of JSON Data in Postgres](https://www.depesz.com/2025/11/29/using-json-json-vs-jsonb-pglz-vs-lz4-key-optimization-parsing-speed/) โ€” JSON vs JSONB for a data type, `pglz` vs `lz4` for compression.. what combination performs best for the most efficient storage of JSON? Hubert does some investigations to find out how different combinations perform, both in terms of query speed and storage space. Hubert depesz Lubaczewski [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/5e9d2ef8.png)](https://posetteconf.com/2026/cfp/) [POSETTE 2026: Call for Proposals (CFP) is Open!](https://posetteconf.com/2026/cfp/) โ€” [POSETTE: An Event for Postgres](https://posetteconf.com/2026/), a free & virtual developer event organized by the Postgres team at Microsoft, is happening June 16-18. The CFP is open until February 1. New and experienced speakers are encouraged to submit! [Get the details](https://posetteconf.com/2026/cfp/). Microsoft sponsor **IN BRIEF:** - [Postgres.app](https://postgresapp.com/) is a popular and easy way to quickly run a Postgres instance on macOS and it's just added [downloads for quickly installing a few popular extensions](https://postgresapp.com/extensions/) (PL/v8, http, pg_parquet, and TimescaleDB). - [AWS has introduced new database savings plans](https://aws.amazon.com/blogs/aws/introducing-database-savings-plans-for-aws-databases/) for its various offerings, including RDS and Aurora, which will benefit those who can commit to a consistent hourly spend over a one year term. - [Schema3D](https://schema3d.com/) is an interesting, experimental way to visualize database schemas in a 3D space. (Use the pencil icon at the top right to provide your own SQL.) [Transparent Data Encryption (TDE) Now Available for Postgres 18](https://percona.community/blog/2025/11/28/tde-is-now-available-for-postgresql-18/) โ€” Percona now ships a build of Postgres 18.1 with fully supported native TDE and asynchronous I/O. TDE offers encryption at the file level and solves the problem of protecting data โ€˜at rest.โ€™ Percona [What is Better: A Lookup Table or an Enum Type?](https://www.cybertec-postgresql.com/en/lookup-table-or-enum-type/) โ€” There are pros and cons both ways and it all depends on your constraints. Laurenz Albe ๐Ÿ“„ [Configuring Postgres Logs: A Practical Guide](https://www.dash0.com/guides/postgresql-logs) โ€“ Goes into more depth than you might expect. Dash0 ๐Ÿ“„ [Unraveling a Postgres Segfault That Uncovered an Arm64 JIT Compiler Bug](https://www.datadoghq.com/blog/engineering/unraveling-a-postgres-segfault/) Bonnefoy, McGarvey and Ward (Datadog) **RELEASES AND CODE:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/cypidq62wbxe1ijxngco.jpg)](https://www.paradedb.com/blog/paradedb-0-20-0) [ParadeDB 0.20.0: Simpler and Faster Elasticsearch-Quality Full-Text Search](https://www.paradedb.com/blog/paradedb-0-20-0) โ€” ParadeDB brings Elastic-quality, ACID guaranteed search capabilities and analytical performance to Postgres. v0.20.0 introduces new conjunction and disjunction operators and a simpler approach to creating indexes, plus more performance all round. Philippe Noรซl [Psycopg 3.3: The Modern PostgreSQL Adapter for Python](https://www.postgresql.org/about/news/psycopg-33-released-3187/) โ€” Gains support for Python 3.14โ€™s template strings, opening up a new way to cleanly write dynamic queries that are still bound safely. [Official homepage.](https://www.psycopg.org/psycopg3/docs/) Psycopg Development Team ๐Ÿ“ฐ Classifieds ๐ŸŒ From single node to global clusters: run PostgreSQL anywhere. [Try pgEdge Enterprise](https://www.pgedge.com/get-started/enterprise-vm). --- ๐Ÿ›ฃ๏ธ [The Road to Next.js](https://www.road-to-next.com/?utm_source=postgres_weekly&utm_medium=referral&utm_campaign=next_course) is a course by Robin Wieruch for learning full-stack web development with Next.js 15 and React 19. - [TimescaleDB 2.24](https://github.com/timescale/timescaledb/releases/tag/2.24.0) โ€“ Time series capabilities for Postgres in an extension. v2.24 adds 'lightning-fast' recompression and continuous aggregates now fully support UUIDv7. - [PEV2 v1.19.0](https://github.com/dalibo/pev2) โ€“ Vue.js component for visualization of Postgres execution plans. - [PeerDB 0.36](https://github.com/PeerDB-io/peerdb) โ€“ Stream data from Postgres to data warehouses, queues and storage engines. - [Supavisor 2.8](https://github.com/supabase/supavisor/releases/tag/v2.8.0) โ€“ Supabase's multi-tenant Postgres connection pooler. - [temBoard 10.0 RC1](https://github.com/dalibo/temboard) โ€“ Manage a Postgres fleet from a web interface. - [PGSync 6.2](https://github.com/toluaina/pgsync) โ€“ Postgres to Elasticsearch/OpenSearch syncing. ๐Ÿ—“ **Upcoming Postgres Events in 2026** - ๐Ÿ‡น๐Ÿ‡ญ [FOSSASIA PGDay 2026 (March 10 in Bangkok)](https://www.postgresql.org/about/event/fossasia-pgday-2026-2563/) โ€” An annual event running alongside the FOSSASIA Summit. [CFP](https://eventyay.com/e/b85fd0f2/cfs) is open till December 15. - ๐Ÿ‡ฎ๐Ÿ‡ณ [PGConf India 2026 (March 11-13 in Bengaluru)](https://www.pgconf.in/conferences/pgconfin2026) โ€” A multi-day event run by the India PostgreSQL User Group. - ๐Ÿ‡ซ๐Ÿ‡ท [pgDay Paris 2026 (March 26)](https://2026.pgday.paris/) โ€” [Its CFP](https://2026.pgday.paris/call-for-papers/) is open until December 19. - ๐Ÿ‡ฉ๐Ÿ‡ช [PostgreSQL Conference Germany 2026 (April 21-22 in Essen)](https://2026.pgconf.de/) - ๐Ÿ‡ง๐Ÿ‡ช [PGConf.BE 2026 (May 5 in Belgium)](https://pgconf.be/) - ๐Ÿ‡จ๐Ÿ‡ฆ [PostgreSQL Development Conference 2026 โ€“ a.k.a. pgconf.dev (May 19 in Vancouver)](https://www.postgresql.org/about/event/postgresql-development-conference-2026-pgconfdev-2543/) - ๐Ÿ‡บ๐Ÿ‡ธ [PG DATA 2026 (June 4-5 in Chicago)](https://2026.pg-data.org/) โ€” The first event of a new conference series with an emphasis on education, developer community building, and outreach to academia. - ๐ŸŒ [POSETTE 2026 (June 16, Virtual/Online)](https://posetteconf.com/2026/) โ€” Microsoft's free, virtual event organized by the Postgres team at Microsoft. [The call for proposals](https://posetteconf.com/2026/cfp/) is open until February 1. _Note: This list is not exhaustive, and we will continue to mention and promote other events over time._ **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).