Let’s say you have two PostgreSQL servers that connect to each other using postgres_fdw. They communicate over TLS and they use client certificates to authenticate. You have a Certificate Authority you have set up, and it has issued server and client certificates for each server. On server one you have server1.crt, server1.key, client1.crt, client1.key and […]
Similarity queries are a popular requirement in many applications that need data integration, record linkage, data cleaning, data de-duplication, and fuzzy matching. PostgreSQL provides many features that allow you to run similarity queries. In order to explore this topic in detail, 2ndQuadrant arranged a live webinar, “Similarity Queries in PostgreSQL”, to dive into this topic […]
Vacuuming is a key feature of PostgreSQL databases to keep databases healthy and optimized. When enabled, autovacuum conserves space by removing obsolete disk usage and optimizes database performance by speeding up sequential scans, among many other benefits. As part of the ongoing PostgreSQL Webinar Series, 2ndQuadrant hosted a webinar on Postgres Vacuuming Through Pictures, which […]
PostgreSQL has quite a number of better algorithmic alternatives to cursors. We’ll start by examining the advantages of Common Table Expressions.
PostgreSQL is a powerful database and supports multiple operating systems. Windows is a first-class example of PostgreSQL supported platforms. In order to explore this topic in detail, 2ndQuadrant arranged a live webinar, “PostgreSQL on Windows”. The session was hosted by Andrew Dunstan, Senior Developer & PostgreSQL Committer at 2ndQuadrant. The webinar covered the following topics: […]
Since PgBouncer runs as a single process, it is not straightforward to make use of multiple CPUs on a host. When you are running on real hardware, this is wasteful, since single-CPU server machines don’t exist anymore, as far as I can tell. When using virtualization, you could just provision a single CPU per virtual […]
PostgreSQL offers many advanced features that applications can use to store information reliably and efficiently for the longer term. One such feature is the ability to control transactions. In the third and final session, Gianni Ciolli, Head of Professional Services at 2ndQuadrant covered: Transactions and Locking: improve transaction flow by reducing contention. The Blind Spot […]
Daniel Gustafsson has done some terrific work on using NSS as an alternative TLS library to OpenSSL for PostgreSQL. I’ve done some work making that build and run on Windows. Daniel recently asked how to get a working NSS on Windows to use for development, and this blog is about that process. First you need […]
One of the interesting new features in PostgreSQL for some time now is the ability to control removal of WAL files using replication slots. The dark side is that replication slots can cause disks to fill up with old WAL, killing the main production server. In this article I explain PostgreSQL replication slots, and how a new feature in PostgreSQL 13 helps prevent this problem.
PostgreSQL offers many advanced features that applications can use to store information reliably and efficiently for the longer term. One such feature is the ability to control transactions. In the second session, Gianni Ciolli, Head of Professional Services at 2ndQuadrant covered: Replicated Transactions: replication can provide extra reliability, if properly used. Performance Expectations: will transactions […]