--- title: "A surprisingly jam packed issue" publication: "Postgres Weekly" issue: 474 published_at: "2022-10-05" canonical_url: "https://postgresweekly.com/issues/474" --- Plus Postgres 15 RC 1, a new way to share real-time database events, and DuckDB adds Postgres querying support. | ✏️ Please note that next week we may delay _Postgres Weekly_ until Thursday, October 13 due to the expected final release of Postgres 15. #​474 — October 5, 2022 [Web Version](https://postgresweekly.com/issues/474) Together with [![Timescale logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_350,h_90/e_make_transparent/co_white,e_outline:7/vpntubykyv5ujmbzw501.png)](https://tsdb.co/pgw-postgresql-timescaledb) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/lptsku1eiqhutlgtukyj.jpg)](https://www.crunchydata.com/blog/real-time-database-events-with-pg_eventserv) [Real-Time Database Events with `pg_eventserv`](https://www.crunchydata.com/blog/real-time-database-events-with-pg_eventserv) — [pg_eventserv](https://github.com/crunchydata/pg_eventserv) is a new Go-powered server that takes events from Postgres via `NOTIFY` and then passes those events to waiting WebSocket clients. _“Building real-time systems this way allows any database client to alter the state of the system and have that alteration propagated to all other clients in real time.”_ Paul Ramsey (Crunchy Data) [PostgreSQL 15 Release Candidate 1 Released](https://www.postgresql.org/about/news/postgresql-15-rc-1-released-2516/) — For the past several years, major Postgres releases have arrived around early October and we’re now counting down to Postgres 15’s final release on _October 13._ This release candidate aims to be “mostly identical” to the final release but provides an opportunity to test and catch last minute bugs, and get extensions running smoothly. Here are [the release notes](https://www.postgresql.org/docs/15/release-15.html), as they stand. PostgreSQL Global Development Group [![\](https://copm.s3.amazonaws.com/dd26edf9.jpg)](https://tsdb.co/pgw-postgresql-timescaledb) [How TimescaleDB Expands PostgreSQL Performance](https://tsdb.co/pgw-postgresql-timescaledb) — Learn how TimescaleDB expands PostgreSQL query performance by 1000x, reduces storage utilization by 90%, and provides time-saving features for time-series and analytical applications—while still being 100% Postgres. Timescale sponsor [Querying Postgres Tables Directly from DuckDB](https://duckdb.org/2022/09/30/postgres-scanner.html) — [DuckDB](https://duckdb.org/) (an in-process SQL OLAP database that could perhaps be called a ‘SQLite for analytics’) can now directly read Postgres tables _while_ Postgres is running, and run queries to speed up complex analytical queries without duplicating data. Hannes Mühleisen (DuckDB) **IN BRIEF:** - Snaplet and Supabase have [open sourced `postgres-wasm`](https://supabase.com/blog/postgres-wasm), a Postgres server that can run _in the browser_ thanks to WebAssembly. An epic project we're digging into right now and will post more on soon. - Ryan Booz has [kicked off PGSQL Phriday](https://www.softwareandbooz.com/pgsql-phriday-001-invite/), a monthly attempt to **encourage folks in the Postgres community to get blogging.** We strongly support this and hope to link to some of your posts. The first prompt is _two truths and a lie_; share three Postgres tips, one of them has to be false! - 📕 [Mastering PostGIS and OpenStreetMap](https://blog.rustprooflabs.com/2022/10/announce-mastering-postgis-openstreemap) by Ryan Lambert has been released. It's a _paid_ book but the level of quality is clearly high as demonstrated by [this freely available extract](https://book.postgis-osm.com/ch_pgosm/denver-area-extract.html). - [How uniqueness guarantees are enforced in Postgres](https://www.highgo.ca/2022/09/30/how-unique-index-works-in-pg/) at the technical, internal level. - [Tuning a Postgres BRIN index](https://j-carson.github.io/2022/10/02/brin/) – they require more handholding than you might first expect. - [Why Nhost Moved from AWS RDS to Postgres on Kubernetes](https://nhost.io/blog/individual-postgres-instances) - [All about `pg_stat_statements`](https://dev.to/yugabyte/all-about-pgstatstatements-27jn) [Are the Majority of Postgres Servers on the Internet Insecure?](https://innerjoin.bit.io/the-majority-of-postgresql-servers-on-the-internet-are-insecure-f1e5ea4b3da3) — _“At most 15% of the approximately 820,000 PostgreSQL servers listening on the Internet require encryption,”_ claims the author, but he goes further than that by looking at how some Postgres _clients_ don’t help matters by defaulting to not using encryption even when it’s possible. _(We think ‘on the Internet’ is doing some heavily lifting in the title, though, as Postgres servers are often behind firewalls, in private networks, and the like.)_ Jonathan Mortensen [How to Get Into Understanding Postgres' Internals](http://blog.cleverelephant.ca/2022/10/postgresql-links.html) — If you want to work deep in the Postgres codebase, Paul shares some pointers to handy resources for learning about how Postgres ticks from the _inside_. Paul Ramsey [Why Didn't `VACUUM` Make Your Table Smaller?](https://www.cybertec-postgresql.com/en/vacuum-does-not-shrink-my-postgresql-table/) — If you’ve ever asked this question, this introduction to what’s going on is for you. In short, you need `VACUUM FULL` – but there are tradeoffs and alternatives to consider. Hans-Jürgen Schönig 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/eerfijuqq0esbyqpoybh.jpg)](https://www.postgresql.org/about/news/announcing-the-release-of-pg_stat_monitor-110-2512/) [pg_stat_monitor 1.1.0: A Query Performance Monitoring Tool](https://www.postgresql.org/about/news/announcing-the-release-of-pg_stat_monitor-110-2512/) — Aims to be an ‘advanced replacement’ for the universally popular `pg_stat_statements` for digging into query origins, execution, planning statistics and details, and more. Percona has [written about how it works before](https://www.percona.com/blog/understand-your-postgresql-workloads-better-with-pg_stat_monitor/). Percona [Dynaboard: The Pro-Code Web App Builder Made for Developers](https://dynaboard.com/?utm_source=cooperpress&utm_medium=email&utm_campaign=procode-q42022) Dynaboard sponsor [pgBackRest 2.41: Reliable Postgres Backup and Restore](https://pgstef.github.io/2022/09/20/pgbackrest_2_41_released.html) — _Backup annotations_ is a new feature for attaching informative key/value pairs to backups to provide extended information. Stefan Fercot - [PL/Haskell 1.0](https://www.postgresql.org/about/news/plhaskell-v10-released-2519/) ↳ Write Postgres functions in Haskell. - [Bytebase 1.5](https://github.com/bytebase/bytebase) ↳ Safe schema change and version control tool. - [serverless-pg 2.0](https://github.com/MatteoGioioso/serverless-pg) ↳ Wrapper for `node-pg` to improve serverless-scale PG connections. - [Jet 2.9](https://github.com/go-jet/jet) ↳ Type safe SQL builder with code gen for Go(lang). - [pg_graphql 0.4.1](https://github.com/supabase/pg_graphql) ↳ GraphQL support for Postgres. **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|*)