--- title: "Heroku goes to Amazon Aurora" publication: "Postgres Weekly" issue: 556 published_at: "2024-05-22" canonical_url: "https://postgresweekly.com/issues/556" --- Plus how fast Postgres compiles, using in-memory disk for temporary tables, and a couple of interesting events. | #​556 — May 22, 2024 [Web Version](https://postgresweekly.com/issues/556) Together with [![Redgate\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_800,h_192/e_make_transparent/co_white,e_outline:9/juuaxaie2hv6pua7rl7k.png)](https://www.red-gate.com/hub/entrypage/postgresql/?utm_source=postgresweekly&utm_medium=email&utm_campaign=mc-202405-t2-sodl-xdb-ubi-gc-all&utm_content=learning_hub) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/jq618vrw8lqcuxlkqocu.jpg)](https://tembo.io/blog/pg-timeseries) [Introducing `pg_timeseries`: A New Time-Series Extension](https://tembo.io/blog/pg-timeseries) — Billed as a simple, open source way to manage time-series data in Postgres, it’s [largely implemented in SQL](https://github.com/tembo-io/pg_timeseries/blob/main/sql/timeseries.sql). They also take time to answer the question _“Why not [Timescale](https://github.com/timescale/timescaledb)?”_ The license, mostly. It is, however, early days for pg_timeseries feature-wise. Sharma and Petersen (Tembo) [From Slow Query to Fast — via Stats](https://render.com/blog/postgresql-slow-query-to-fast-via-stats?trk=feed_main-feed-card_feed-article-content) — We previously linked to Render’s [‘Simple Query with a Big Problem’](https://render.com/blog/postgresql-simple-query-big-problem) – here’s the followup digging into _why_ their simple query was taking so long to run and the ways they dug into, and fixed, the issue. Some useful guidance here. Eric Fritz (Render) [![\](https://copm.s3.amazonaws.com/c884f92d.png)](https://www.red-gate.com/hub/entrypage/postgresql/?utm_source=postgresweekly&utm_medium=email&utm_campaign=mc-202405-t2-sodl-xdb-ubi-gc-all&utm_content=learning_hub) [PostgreSQL Learning Hub from Redgate](https://www.red-gate.com/hub/entrypage/postgresql/?utm_source=postgresweekly&utm_medium=email&utm_campaign=mc-202405-t2-sodl-xdb-ubi-gc-all&utm_content=learning_hub) — Explore PostgreSQL content, learn about upcoming events, join community discussions, and discover how Redgate tools can help solve your database challenges. Redgate Software sponsor [Heroku Introduces _Heroku Postgres Essentials_](https://blog.heroku.com/heroku-postgres-essential-launch) — A pioneer of scaling out a huge Postgres platform, Heroku is still continuing to improve things. These new plans are built atop Amazon Aurora and focus on the lower end (replacing their Mini and Basic levels) while still providing far more performance than before (plus, they support `pgvector`). Heroku **IN BRIEF:** - 📊 Core contributor Peter Eisentraut loves to test how fast Postgres compiles (probably because he has to do it a lot) and has taken [a look at how the latest Clang 18 and GCC 14 fare.](https://peter.eisentraut.org/blog/2024/05/21/new-compilers-new-timings) A great return to form for Clang, though GCC is getting slower.. - Gabriele Bartolini presents [a touching tribute to Simon Riggs,](https://www.gabrielebartolini.it/articles/2024/05/16-years-after-the-launch-of-2ndquadrant-italy-remembering-simon-riggs/) the founder of 2ndQuadrant, who [recently died,](https://m6n.io/@fuzzychef/112172393647826741) as well as a little history of 2ndQuadrant's presence in Italy. - This year's [Stack Overflow Developer Survey](https://stackoverflow.az1.qualtrics.com/jfe/form/SV_6rJVT6XXsfTo1JI) has just opened – remember to show your love for Postgres.. 😄 - 🇬🇷 PGConf.EU 2024 takes place in Athens, Greece this October, and it's [currently looking for sponsors.](https://www.postgresql.org/about/news/call-for-sponsors-for-pgconfeu-2024-is-now-open-2864/) [When Postgres Said 'No Thanks, I Don't Need Your Index'](https://jaywhy13.hashnode.dev/that-time-postgresql-said-no-thanks-i-dont-need-your-index) — It’s story time! Jean-Mark presents a ‘tale of victory’ after running into problems optimizing a query. Let the negotiations begin.. Jean-Mark Wright [Using In-Memory Disk for Postgres' Temporary Files](https://pgstef.github.io/2024/05/20/in_memory_tmp_files.html) — Postgres produces temporary files under various circumstances, including when executing parallel queries, and Stefan wanted to see if using a RAM-based file system for them would yield improvements. It does - a bit. Stefan Fercot 📰 Classifieds Get ready for [POSETTE](https://aka.ms/posette-schedule)! A free, virtual developer event for Postgres (Jun 11-13). Tune into one or many of 42 talks across 4 livestreams! --- 📅 [Moar Serverless 2024](https://cfe.dev/events/moar-serverless-2024/) is a free, one day online event taking place on May 23 (tomorrow) with several speakers sharing the latest on building serverless apps. [How to Collapse Your Stack Using Postgres for.. _Everything_](https://www.timescale.com/blog/how-to-collapse-your-stack-using-postgresql-for-everything/) — If ‘stack sprawl’ is a problem for you or your company, why not offload more of the work to the trusty database you already know and love? James Blackwood-Sewell (Timescale) 📄 [What We're Excited About in Postgres 17](https://www.timescale.com/blog/what-were-excited-about-postgresql-17/) Timescale 📺 [Scaling Clubhouse from 10K to 10 Million Users in 6 Months with Postgres](https://www.stepchange.work/blog/scaling-clubhouse-from-10k-to-10-million-users-in-6-months-with-postgres) Harry Tormey and Luke Demi 📄 [Optimizing SQL Queries: Some Postgres Best Practices](https://wirekat.com/optimizing-sql-based-on-postgresql/) – A summary of some basics. Markus Wirekat 📄 [Row-Level Transformations in Postgres CDC Using Lua](https://blog.peerdb.io/row-level-transformations-in-postgres-cdc-using-lua) Sai Srirampur (PeerDB) 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/v8y4aivdk8jebp5p65pb.jpg)](https://github.com/eakmanrq/sqlframe) [SQLFrame: Taking the Spark Out of PySpark by Generating SQL](https://github.com/eakmanrq/sqlframe) — A dataframe library that can run PySpark code on BigQuery, DuckDB, and, yes, Postgres. It converts DataFrame operations directly into SQL. There's a [longer explanation and rationale here.](https://github.com/eakmanrq/sqlframe/blob/main/blogs/sqlframe_universal_dataframe_api.md) Ryan Eakman [PgHero 3.5: A Performance Dashboard for Postgres](https://github.com/ankane/pghero) — A dashboard built as a (Ruby on) Rails engine to look at basic performance stats including live queries, maintenance status, and connections. Andrew Kane - [Pgpool-II 4.5.2, 4.4.7, 4.3.10, 4.2.17 and 4.1.20](https://www.postgresql.org/about/news/pgpool-ii-452-447-4310-4217-and-4120-released-2859/) - [pgRoll 0.6](https://github.com/xataio/pgroll) – Zero-downtime, reversible schema migrations for Postgres. [v0.6](https://github.com/xataio/pgroll/releases/tag/v0.6.0) adds several new features. - [Pigsty 2.7](https://github.com/Vonng/pigsty/releases/tag/v2.7.0) – The 'batteries included' Postgres distribution gains over 20 new included extensions. - [DBMate 2.16](https://github.com/amacneil/dbmate) – Lightweight, framework-agnostic database migration tool. - [Bytebase 2.17](https://github.com/bytebase/bytebase/releases/tag/2.17.0) – Database devops and CI/CD system for teams. - [Bob 0.26](https://github.com/stephenafamo/bob/releases/tag/v0.26.0) – SQL query builder and ORM/Factory generator for Go. - [pg_dumpbinary v2.17](https://www.postgresql.org/about/news/pg_dumpbinary-v217-released-2862/) – Dump databases to a _binary_format. **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|*).