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...
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...
Like in the parable of the Blind Men and an Elephant, Postgres code can look like many different applications of computer science depending on where you look: operating systems, transactions...
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...
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...
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...
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...
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...
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...
![Postgres Vacuuming Through Pictures [Webinar]](/sites/default/files/styles/blog_image/public/blog_posts_images/Postgres-Vacuuming-Through-Pictures-Webinar.png?h=ce5fe46c&itok=TMeLBz3a "Postgres Vacuuming Through Pictures [Webinar]")
