--- title: "We're all in charge of Postgres" publication: "Postgres Weekly" issue: 563 published_at: "2024-07-17" canonical_url: "https://postgresweekly.com/issues/563" --- Plus how does Postgres fare against Redis as a cache? | #​563 — July 17, 2024 [Web Version](https://postgresweekly.com/issues/563) Together with [![Honeybadger\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_600,h_100/e_make_transparent/co_white,e_outline:7/jxeurjkyc4lup8ge7luq.png)](https://www.honeybadger.io/tour/logging-observability/?utm_source=postgresweekly&utm_medium=email&utm_campaign=2024-07-17-postgresweekly-primary) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/xdevwityrinadlvs7ujg.jpg)](https://www.enterprisedb.com/blog/who-is-in-charge-of-postgres) [Who's in Charge of Postgres?](https://www.enterprisedb.com/blog/who-is-in-charge-of-postgres) — Postgres is different to many databases by not being directly under the control of a benevolent leader or corporation that drives its development. It has a core team, the _PostgreSQL Community Association_ holds the trademark, but who’s ‘in charge’? All of us, suggests Bruce. Bruce Momjian ⚠️ In the e-mail version of this newsletter, we made an error in who holds the trademark. A proper correction will be issued in next week's issue. Thanks to Jonathan Katz for highlighting this! [Can Postgres Replace Redis as a Cache?](https://medium.com/redis-with-raphael-de-lio/can-postgres-replace-redis-as-a-cache-f6cba13386dc) — Redis is a popular, high performance in-memory data storage server commonly used for caching, but if we can ["just use Postgres for everything"](https://www.amazingcto.com/postgres-for-everything/), could Postgres take on the job instead? Raphael investigates. Raphael De Lio [![\](https://copm.s3.amazonaws.com/e21c7416.png)](https://www.honeybadger.io/tour/logging-observability/?utm_source=postgresweekly&utm_medium=email&utm_campaign=2024-07-17-postgresweekly-primary) [Full-Stack Observability from Honeybadger](https://www.honeybadger.io/tour/logging-observability/?utm_source=postgresweekly&utm_medium=email&utm_campaign=2024-07-17-postgresweekly-primary) — Honeybadger's new logging platform is a bit like Splunk, DataDog, or CloudWatch Logs, but with just the good parts and a reasonable price tag. Plus, it's easy to integrate with Crunchy Bridge, Journald, AWS, and more! Honeybadger sponsor [Autovacuum Tuning Basics](https://www.enterprisedb.com/blog/autovacuum-tuning-basics) — Running `VACUUM` manually reclaims wasted space/bloat in tables caused by deleted and updated rows. The _autovacuum_ system, however, takes this job away from us, and can be tweaked to get the right space/performance tradeoffs for your situation. Tomas Vondra **QUICK BITS:** - 🇬🇧 [PGDay UK 2024 has published its schedule](https://pgday.uk/events/pgdayuk2024/news/pgday-uk-2024-schedule-published-9/) – it takes place in London this September and [registration is open.](https://2024.pgday.uk/registration/) - 🇺🇸 The [PASS Summit](https://passdatacommunitysummit.com/) database event is also back in Seattle this November. They've unveiled their [Postgres-specific lineup here.](https://passdatacommunitysummit.com/sessions/?databaseManagementTopic=PostgreSQL) - _Amazon RDS Data API for Aurora PostgreSQL_ is [now available in 10 additional AWS regions.](https://aws.amazon.com/about-aws/whats-new/2024/07/amazon-rds-data-api-aurora-postgresql-additional-regions/) - Serverless Postgres platform _Xata_ has [introduced multi-version schema migrations.](https://xata.io/blog/multi-version-schema-migrations) - [Ubicloud's Ozgun Erdogan](https://postgresql.life/post/ozgun_erdogan/) is this week's _PostgreSQL Person of the Week_interviewee. [Using AI to Generate Data Structures for Postgres](https://www.cybertec-postgresql.com/en/using-ai-to-generate-data-structures/) — It might be some time before we trust LLMs and AI models to diagnose diseases or run power plants, but when it comes to helping you define models and schemas, they can quickly point you in the right direction. Hans-Jürgen Schönig ▶[Discussing the Postgres Startup Ecosystem](https://www.youtube.com/watch?v=fIqYOXhMR-o) — Nikolay and Michael of the [Postgres FM podcast](https://postgres.fm/) discuss the rapidly shifting and growing commercial ecosystem around Postgres, including companies like Neon, Tembo, and Aiven. _(35 minutes.)_ Postgres․FM [Keyset Pagination with Descending Order](https://www.cybertec-postgresql.com/en/keyset-pagination-with-descending-order/) — Some workarounds for an interesting sorting and pagination problem you can run into with SQL. Laurenz Albe 📄 [System Logs Aggregation with Postgres](https://tuxnet.dev/post/20240712_central-logs-postgres/) – Talking of using Postgres for _everything.._ Jakub Kołodziejczak 📄 [Using `pg_easy_replicate` for Setting Up Logical Replication and Switchover](https://www.shayon.dev/post/2024/195/use-pg_easy_replicate-for-setting-up-logical-replication-and-switchover-in-postgresql/) Shayon Mukherjee 📄 [How Expensive Is It to Maintain Extended Statistics?](https://danolivo.substack.com/p/how-expensive-is-it-to-maintain-extended) Andrei Lepikhov 📄 [Putting DuckDB in Postgres to Query Iceberg](https://blog.paradedb.com/pages/iceberg_lakehouse) Ming Ying (ParadeDB) 📄 [How to Install TimescaleDB on AWS](https://www.timescale.com/blog/how-to-install-timescaledb-on-aws/) Juan Jose (Timescale) **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|*).