PostgresJun 13, 2025Comparing Native Postgres, ElasticSearch, and pg_search for Full-Text SearchImplementing text search in Postgres is trivial. You can do it as simply as this But like most simple things in SQL, it’s only simple when your data is simple—when you hit anything approaching scale, the simple things become hard. Full text search is precisely one of these cases....Ben Hagan
PostgresJun 09, 2025Managing Postgres Directly in VS CodeMicrosoft recently introduced a Visual Studio Code extension for Postgres database management. Similar in functionality to tools like PgAdmin or DBeaver, this extension embeds Postgres management directly into VSCode and comes fully integrated with GitHub Copilot, allowing it to ...Sam Harrison
PostgresMay 28, 2025The Difference Between Postgres Logging and PGAuditPostgres has some excellent internal logging capabilities. With a simple logging_collector = on and a couple of other config flags, you can get an incredibly detailed picture of your Postgres operations, from individual SQL statements to connection attempts, error messages, and l...Monica Steinke
PostgresMay 27, 2025Recreating S3 in Postgres using PostgRESTStoring files directly in a database is generally discouraged in favour of dedicated object storage like S3 or Azure Blob, which is the more scalable and cost effective approach. However, in practice, you might sometimes find yourself putting binary data in a relational database ...Sam Harrison
PostgresMay 23, 2025Escaping the AWS RDS Cost SpiralIf you look at RDS pricing, everything looks quite affordable (storage, compute, backups) – so how are so many teams spending six figures on it? Usage is part of the story, of course, but those bills are also very inflated. At scale, there’s more going on. Scaling a database does...Carlota Soto
PostgresMay 08, 2025Postgres 18 Beta Is Out: 7 Features You Should Know AboutPostgres 18 Beta 1 just shipped. As with previous major releases, this beta includes previews of all features planned for general availability. Read the release notes for the full list of updates, but we’re gonna go through some highlights on this post. New in Postgres 18 Asynchr...Heikki Linnakangas
PostgresMay 05, 2025Rethinking Snapshots at Scale: Neon vs AWS RDSSnapshots are a critical safety net for any team running Postgres in production. If you’re using AWS RDS, you’re probably relying on them mostly as protection against accidental changes. But if your database grows to many terabytes, the experience of actually using those snapshot...Carlota Soto
PostgresApr 11, 2025The True Cost of Slow Postgres RestoresWhen a Postgres failure happens, the time it takes to recover can mean the difference between a relatively minor hiccup and a major business crisis. We regularly hear anecdotes from our customers on this topic, but we also wanted to gather some data—so we surveyed 50 developers m...Carlota Soto
PostgresApr 03, 2025The Noisy Neighbor Problem in Multitenant ArchitecturesReddit’s answer for solving noisy neighbors is simple Have a talk with them, if you can stay calm, be as straight forward as possible. Don’t bend on your position. At least find out what the other neighbors think. Good advice, but it can be difficult to talk to CPUs; they tend no...Carlota Soto
PostgresMar 26, 2025Search From a Million Books in Milliseconds With Neon and pg_searchWe just announced that pg_search is available on Neon, making it easier than ever to build fast, full text search experiences with Postgres. To demonstrate its performance, we forked Vercel’s Book Inventory template and replaced the AI powered search with native PostgreSQL full t...Rishi Raj Jain
