Tame Complex PostgreSQL Schemas with Atlas, a Terraform for Databases | Atlas | Manage your database schema as code
Discover how Atlas helps teams manage complex PostgreSQL schemas with ease, enabling faster and reliable migrations| atlasgo.io
We're excited to announce the general availability of Heroku Postgres version 17 , packed with new features and enhancements to your database performance. And that's not all - we're also introducing a game-changing feature that streamlines your upgrade experience . This new method of version upgrade is now the default, so you can try it to upgrade to Postgres 17! Postgres 17: Powering your applications with enhanced performance and security Before we dive into the simplicity of the new upgrad...| Heroku
Your organization may have many reasons to move a cloud service from one provider to another. Maybe you’ve found a better performance-versus-cost balance elsewhere. Maybe you’re trying to avoid vendor lock-in. Whatever your reasons, the convenience and general interoperability of cloud services today put you in the driver's seat. You get to piece together the tech stack and the cloud provider(s) that best align with your business. This includes where you turn for your PostgreSQL database ...| Heroku
We’re thrilled to launch our new Heroku Postgres Essential database plans . These plans have pgvector support, no row count limits, and come with a 32 GB option. We deliver exceptional transactional query performance with Amazon Aurora as the backing infrastructure. One of our beta customers said: “The difference was noticeable right from the start. Heroku Postgres running on Aurora delivered a boost in speed, allowing us to query and process our data faster.” Our Heroku Postgres Essent...| Heroku
We’re pleased to introduce the pgvector extension on Heroku Postgres . In an era where large language models (LLMs) and AI applications are paramount, pgvector provides the essential capability for performing high-dimensional vector similarity searches. This allows Heroku Postgres to quickly find similar data points in complex data, which is great for applications like recommendation systems and prompt engineering for LLMs. As of today, pgvector is fully compatible with all Production-tier ...| Heroku
One of the significant improvements in PG18 is AIO. What are some basic tuning recommendations?| Tomas Vondra
Learn how to get highly available reads across multiple QuestDB instances using open-source or enterprise deployments.| QuestDB Blog
How to create a private on-demand PostgreSQL instance accessible only| /dev/posts/
Using RLS can be cumbersome, because it's usually expected to rely on the user name. Could we use JWT to establish a 'trusted context'?| Tomas Vondra
Funny and weird behavior with modern SSD devices, and how it impacts query execution.| Tomas Vondra
We are thrilled to join forces with ClickHouse to make it seamless for customers to move data from their Postgres databases to ClickHouse and power real-time analytics and data warehousing use cases. We released the ClickHouse target connector for Po...| PeerDB Blog
At PeerDB, we are building a fast and simple way to replicate data from Postgres to data warehouses like Snowflake, ClickHouse etc. and queues such as Kafka, Redpanda etc. We implement Postgres Change Data Capture (CDC) to reliably replicate changes ...| PeerDB Blog
Earlier this week, we launched PeerDB Streams, our latest product offering for real-time replication from Postgres to queues and message brokers such as Kafka, Redpanda, Google PubSub, Azure Event Hubs, and others. Today, we are announcing one of the...| PeerDB Blog
We spent the past 7 months building a solid experience to replicate data from Postgres to Data Warehouses such as Snowflake, BigQuery, ClickHouse and Postgres. Now, we want to expand and bring a similar experience for Queues. With that spirit, we are...| PeerDB Blog
pg_dump and pg_restore are reliable tools for backing up and restoring Postgres databases. They're essential for database migrations, disaster recovery and so on. They offer precise control over object selection for backup/restore, dump format option...| PeerDB Blog
Introduction Logical Replication is one of the many ways a Postgres database can replicate data to other Postgres database (a.k.a standby). Logical replication directly reads from the write-ahead log (WAL), recording every database change, avoiding t...| PeerDB Blog
At PeerDB, we are building a fast and a cost-effective way to replicate data from Postgres to Data Warehouses and Queues. Today we are releasing our Azure Event Hubs connector. With this, you get a fast, simple, and reliable way to Change Data Captur...| PeerDB Blog
At PeerDB, we are building a fast and a cost-effective way to replicate data from Postgres to Data Warehouses such as Snowflake, BigQuery, ClickHouse, Postgres and so on. All our customers run Postgres at the heart of the data stack, running fully ma...| PeerDB Blog
Building the first truly self-driving PostgreSQL: zero downtime upgrades, AI-powered automation, and a roadmap to full database autonomy.|
On a recent project at Hashrocket, we had to use dblink in production as part of our set up for communicating with a legacy database. While our overall experience was positive, we had a couple of hiccups along the way. Let's talk about the lessons we learned! What is dblink? dblink is a Postgres command that allows you to connect to and execute queries on a remote database. There are a number of dblink-related commands in Postgres depending on your use case (from dblink_connect to dblink_exec...| Hashrocket
Hands-on guide to the upcoming SQL/PGQ graph syntax using a patched Postgres 18 beta.| Gavin Ray Blog
Discover how Atlas helps teams manage complex PostgreSQL schemas with ease, enabling faster and reliable migrations| atlasgo.io
July 31st – Aug 3rd Portland State University @ Smith Memorial Student Union building This year Mark and I, with Richard Yen and Gabrielle Roth’s help, have been organizing the database…| PDXPUG
A follow up to my blog post exploring how often we pick the optimal query plan. Instructions how to reproduce it, why it happens and how to address it.| Tomas Vondra
In my previous post, I wrote about exporting the postgres database for devlibrary from fly.io to a local file. Now, I want to convert that into a sqlite database, so I can get rid of the dependency on a separate database server.| Nithin Bekal
Nithin Bekal's blog about programming - Ruby, Rails, Vim, Elixir.| nithinbekal.com
AWS RDS supports blue/green deployments to support database maintainence. In a blue/green deployment, you have one production (blue) and one staging (green) database. You can safely make changes to the green instance without affecting production and promote it to be the main instance. When you enable blue/green updates, Pulumi will temporarily set up a blue/green deployment for the duration of the update to minimize downtime. There are many benefits to using blue/green deployments for updates...| Pulumi Blog
An evaluation of how often Postgres picks the optimal plan for simple scan queries.| Tomas Vondra
At work, we recently upgraded our multi-terabyte PostgreSQL database| ananthakumaran.in
Details for extension authors for how to use the new PG_MODULE_MAGIC_EXT macro introduced in PostgreSQL 18.| ❖ Just a Theory
Benchmarking complex systems can be difficult. Here's a problem I'm currently investigating, possibly related to process scheduling.| Tomas Vondra
Upgrade to Heroku Postgres 17! Enjoy enhanced performance, new features, and security updates. Our 1-Step process makes upgrading easy.| Heroku
Advanced Patch Feedback Session (APFS) at pgconf.dev 2025 - what was the session for, was it useful?| Tomas Vondra
Narrative version of a PGConf.dev talk covering the many issues I stumbled upon while designing a universal packaging format for PostgreSQL extensions, maintaining pgt.dev packages, and experimenting with CloudNativePG immutability.| Just a Theory
Step-by-step instructions to publish PostgreSQL extensions and utilities on the PostgreSQL Extension Network (PGXN).| Just a Theory
At the final Mini-Summit of 2025, Gabriele Bartolini gave an overview of PostgreSQL extension management in CloudNativePG.| Just a Theory
Please welcome 2025 Google Summer of Code contributor Mankirat Singh, who will be developing an ABI compliance checker for the PostgreSQL maintenance branches.| ❖ Just a Theory
The last Mini-Summit of the year features Gabriele Bartolini talking about extension management in CloudNativePG.| ❖ Just a Theory
The last Mini-Summit of the year features Gabriele Bartolini talking about extension management in CloudNativePG.| Just a Theory
Last week Floor Drees moderated a panel on “The User POV” at the fourth Extension Mini-Summit. Read on for the transcript and link to the video.| Just a Theory
Suggestions to PostgreSQL extension maintainers to make some tweaks to your .control files and Makefiles.| ❖ Just a Theory
Join our fine panel on Wednesday at Extension Mini Summit #4 to hear all about “The User POV” — for better and for worse!| Just a Theory
patch idea: dynamic tuning for IN queries| Tomas Vondra
Join our fine panel on Wednesday at Extension Mini Summit #4 to hear all about “The User POV” — for better and for worse!| ❖ Just a Theory
When should a Postgres extension be pre-loaded and when should it not? Should it be loaded in user sessions or at server startup? Read on for answers.| tembo.io
A fix for the error: 'strchrnul' is only available on macOS 15.4 or newer Postgres compile error.| ❖ Just a Theory
Join us at PostgresSQL Extension Mini Summit #3 this week, where PostgreSQL Debian packaging maintainer Christoph Berg will takes on a tour of APT extension packaging.| Just a Theory
Join us at PostgresSQL Extension Mini Summit #2 this week, where PostgreSQL committer Peter Eisentraut will discuss the extension search path patch.| Just a Theory
About| theory.github.io
Last week Christoph Berg, who maintains PostgreSQL’s APT packaging system, gave a very nice talk on that system. Herein lie the transcript and links to the slides and video.| ❖ Just a Theory
Join us at PostgresSQL Extension Mini Summit #3 this week, where PostgreSQL Debian packaging maintainer Christoph Berg will takes on a tour of APT extension packaging.| ❖ Just a Theory
I recently built a hybrid query engine at work. In this post, I| ananthakumaran.in
{~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~} { } { [Orange card with large black text reading "Implementing an Extension Search Patch". Smaller text below reads "Peter Eisentraut, EDB" and "03.26.2025". A photo of Peter speaking into a mic at a conference appears on the right. ] } { https://justatheory.com...| Just a Theory
Link: https://theory.github.io/sqljson/ Based on the recently-released Go [JSONPath] and [JSONTree] playgrounds, I've updated the design and of the [SQL/JSON Playground][play]. It now comes populated with sample JSON borrowed from [RFC 9535], as well as a selection of queries that randomly populate the query field on each reload. I believe this makes the playground nicer to start using, not to mention more pleasing to the eye. The playground has also been updated to use the recently-released ...| Just a Theory
A transcript of from the second PostgreSQL Extension Mini Summit, “Implementing an Extension Search Path”, by Peter Eisentraut.| Just a Theory
A rough transcript of my talk “State of the Extension Ecosystem”.| ❖ Just a Theory
Simplify your PostgreSQL database management with Toad Data Studio Schema Compare, offering powerful features for efficient comparison and synchronization: Related Links The post Toad Data Studio Schema Compare for PostgreSQL appeared first on Toad World Blog.| Toad World Blog
Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version by: $pipinstall-Upgcli Check detailed instructions if you're having difficulty. This version adds more color schemes to the syntax highlighting. An attempt to add support for PyPy by using psycopg2cffi failed. Python 3 support for psycopg2cffi was only added recently and there are still a few corner cases where it fails. Features: Add syntax color styles to c...| pgcli
We’re doing it again! The PostgreSQL Extension Ecosystem Summit returns to PGConf.dev. We’ll again be looking at indexing, discovery, packaging, and core support. And we’ll once again be hosting a series of “Mini Summits” leading up to the event. Join us!| ❖ Just a Theory
A more accurate title would’ve been porting Postgres’ conditional selectivity to MySQL, but you’d ask me what’s conditional selectivity then! This blog post series will explain both.| Uddeshya’s Musings
Welcome to part 2 of the series, in this post, we’ll discuss implementing a new histogram style inspired by Postgres in MySQL for estimating row selectivity.| Uddeshya’s Musings
Different approaches for tracking visitor counts with PostgreSQL.| Supabase
Correcting for spelling mistakes If you search "trgrams in pstgres" in Google, you'll get results for "trigrams in postgres". To say that is useful is an understatement! Recently at work I wanted to search a table of tags, but I wanted to account for…| Leigh Halliday's RSS Feed
Race conditions A race condition or race hazard is the behavior of an electronic, software or other system where the output is dependent on the sequence or timing of other uncontrollable events. It becomes a bug when events do not happen in the order…| Leigh Halliday's RSS Feed
Intro to MongoDB MongoDB is an object or document based database... in other words, a NoSQL database. This puts it in contrast to databases such as MySQL, PostgreSQL, or SQLite, who store their data relationally in a tabular format. MongoDB stores…| Leigh Halliday's RSS Feed
Why do this? Recently at work we had 1 data model that was getting a bit out of control. When we first modelled the data it made sense, but over time business requirements change and we discovered that the model made more sense to be split in half to…| Leigh Halliday's RSS Feed
What is PgHero? PgHero is a gem written by Andrew Kane for getting quick insights into how your Postgres database is performing and where there is room for improvement. It provides a quick overall status of your database, a look at the queries…| Leigh Halliday's RSS Feed
The Problem Say you have a table of people and you want to sort them alphabetically by their nickname in descending order (Z - A). That works great as long as everyone has a nickname, but what happens when one doesn't? What you'll get is a result…| Leigh Halliday's RSS Feed
In this episode, the third portion of the stream covers how I migrated my Heroku-backed Postgres database to SQLite. I finished the migration of my app from running on Heroku to running on DigitalOcean.| Matt Layman
A proposal to modify the PostgreSQL core so that all files required for an extension live in a directory named for the extension, along with a search path to find extension directories.| Just a Theory
Notes and links from the Extension Ecosystem Summit EU 2024 and my first time at PGConf EU. Plus thoughts and photos from ancient sites and archeological museums I visited.| Just a Theory
2024 Thursday October 24th Meeting 6:30pm:8:30pm Location: American Red Cross 3131 N Vancouver Ave · Portland, OR Speaker: Grant Holly Pgbouncer is a popular tool for Postgres users at any scale. O…| PDXPUG
A request for comments on a new PGXN RFC for signing releases, plus a link to an initial implementation.| Just a Theory
The sequel to the successful PGConf.dev event, the Extension Ecosystem Summit EU will showcases some exemplary extension use cases.| Just a Theory
We had an interesting incident at work recently. We run huge databases on PostgreSQL, and to reduce disk fragmentation, we run pg_repack[1] on a regular basis. This tool rewrites tables and indexes so that they are stored in contiguous blocks on disk. It reduces the overhead of disk seeks, improves read performance, and reduces the size of the database.| dineshgowda
Today I released pgxn_meta v0.1.0, a Rust crate and executable for validating PGXN Meta v1 and v2 META.json files.| ❖ Just a Theory
How much storage does a single row in a Postgres table take?| Relentless Coding
Introduction In this blog, we’ll go over the different methods we can use to encrypt and decrypt data in a PostgreSQL database. Having some experience with Linux and PostgreSQL is necessary, while experience with encryption is not but is nice to have. This blog was written using PostgreSQL 16 running on Ubuntu 23.04. First I’ll| Highgo Software Inc. - Enterprise PostgreSQL Solutions
Introduction In this blog, we'll be going over some more advanced topics new in Postgres 16. Having some experience with Linux, Postgres, and SQL is necessary as we'll not only be going over these new features but also how to implement them. This blog was written using PostgreSQL 16 (Development Version) running on Ubuntu 23.04.| Highgo Software Inc. - Enterprise PostgreSQL Solutions
Introduction This blog is aimed at beginners trying to learn the basics of PostgreSQL and Python but already have some experience under their belt. For this tutorial, we will assume you have PostgreSQL correctly installed on Ubuntu. All of these steps were done using PostgreSQL 16 (development version) and Python 3.11.4 on Ubuntu 23.04. We’ll| Highgo Software Inc. - Enterprise PostgreSQL Solutions
Introduction This blog is aimed at beginners trying to learn the basics of PostgreSQL and PGPool but already have some experience under their belt. For this tutorial, we will assume you have PostgreSQL correctly installed on Ubuntu. All of these steps were done using PostgreSQL 16 (development version) and PGPool 4.4.3 on Ubuntu 23.04. We’ll| Highgo Software Inc. - Enterprise PostgreSQL Solutions
Introduction This blog is aimed at beginners trying to learn the basics of PostgreSQL and HAProxy but already have some experience under their belt. For this tutorial, we will assume you have PostgreSQL correctly installed on Ubuntu. All of these steps were done using PostgreSQL 16 (development version) and HAProxy 2.6.9 on Ubuntu 23.04. We'll| Highgo Software Inc. - Enterprise PostgreSQL Solutions
1. Introduction Recently in my development work, a custom connection is required to be maintained between a PG backend on primary and another PG backends on standby nodes to communicate custom data in addition to the existing walsender/walreceiver connection that streams WAL data. Of course, I could just create a new standalone backend and maintain… Read more The post Maintain a custom PG to PG Connection With libpq’s COPY protocol first appeared on Highgo Software Inc.. The post Maintain...| Highgo Software Inc.
Would it be possible to distribute Postgres extension binaries via Open Container Registries? Tune in to find out!| ❖ Just a Theory
We have created a new OpenFaaS template for C# and .NET 8.0 and it’s based on the Minimal API of ASP.NET Core.| OpenFaaS - Serverless Functions Made Simple
Request for comments on a sketch of a new metadata standard for Postgres extension packaging, distribution, and delivery, building on the PGXN Meta Spec to address its shortcomings and emerging use cases 12 years on.| ❖ Just a Theory
A proposal for an additional level of name uniqueness for Postgres extension packaging and distribution, based on URIs.| ❖ Just a Theory
Use Adaptive Retrieval to improve query performance with OpenAI's new embedding models| Supabase
In my last post, I showed you how you could use a number of SQL tricks to generate a class of fractals known as the “escape-time fractals”. In this post I’ll show you how you can use the same … Read the rest The post Generating Fractals with Postgres: Self-Similar Fractals appeared first on malisper.me.| malisper.me
This post is based on half of a talk I gave at !!con. If you want to watch the talk, you can find it here. One not too well known aspect of SQL is that it’s Turing complete. This … Read the rest The post Generating Fractals with Postgres: Escape-Time Fractals appeared first on malisper.me.| malisper.me
I recently gave a talk at !!Con West about how you can use some of the dark corners of SQL to generate fractals. You can watch the recording here: --- To summarize the video, I write SQL queries that generate two … Read the rest The post Generating Fractals with SQL Queries appeared first on malisper.me.| malisper.me
After being in beta for several months, Perfalytics is now generally available. Perfalytics is my attempt to bring a new approach to database performance. Perfalytics integrates directly with your database to collect detailed performance information about your queries. Based on this information, Perfalytics then makes recommendations on how to optimize your queries. I built the […]| malisper.me
pgvector 0.6.0 brings a significant improvement: parallel index builds for HNSW. Building an HNSW index is now up to 30x faster for unlogged tables.| Supabase
The Go package ecosystem uses distributed publishing to release modules without authentication or uploads. Could we do something similar for Postgres extensions?| ❖ Just a Theory
Supavisor is now used across all projects, providing a scalable and cloud-native Postgres connection pooler that can handle millions of connections| Supabase
Published: Fri 05 April 2019| www.pgcli.com
After the update of pgcli to use prompt-toolkit 2.0, there were quite a few complaints| www.pgcli.com
