Since the release of v3, Postgres-BDR has evolved into the go-to clustering technology built specially for businesses that require geographically distributed databases with multiple masters. To get an update on Postgres-BDR’s development, new features, and future roadmap, 2ndQuadrant held the pglogical and Postgres-BDR Update webinar as part of its PostgreSQL webinar series. The webinar was […]
+39 0574 159 3000
JOIN LATERAL
/2 Comments/in Elein’s PlanetPostgreSQL, PostgreSQL /by EleinLATERAL The primary feature of LATERAL JOIN is to enable access elements of a main query in a subquery which can be very powerful. Several common uses of LATERAL are to: denormalize arrays into parent child tables aggregation across several tables row or action generation. Note, however, that the subquery will execute for each main […]
Webinar: Achieving High Availability with PostgreSQL [Follow Up]
/0 Comments/in Liaqat's PlanetPostgreSQL /by Liaqat AndrabiGeo-redundancy of PostgreSQL database backups with Barman
/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniBarman 2.6 introduces support for geo-redundancy, meaning that Barman can now copy from another Barman instance, not just a PostgreSQL database.
PostgreSQL with passphrase-protected SSL keys under systemd
/0 Comments/in Eisentraut's PlanetPostgreSQL /by Peter EisentrautPostgreSQL supports SSL, and SSL private keys can be protected by a passphrase. Many people choose not to use passphrases with their SSL keys, and that’s perhaps fine. This blog post is about what happens when you do have a passphrase. If you have SSL enabled and a key with a passphrase and you start […]
Webinar: Banking on Postgres – Financial Application Considerations [Follow up]
/0 Comments/in Liaqat's PlanetPostgreSQL, PostgreSQL, Webinars /by Liaqat AndrabiThe demand for PostgreSQL within the financial industry has been rapidly increasing in the recent years; mainly due to reduction in licensing costs, better choice of open source tools, and the robust enterprise features that PostgreSQL provides. 2ndQuadrant hosted the “Banking on Postgres” webinar to discuss attributes of financial databases based on Postgres, configuration processes, […]
PG Phriday: Terrific Throughput Tracking
/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasPostgres has a lot of built-in information functions that most people don’t know about. Some of these are critical components to identifying replication lag, but what if we could use them for something else, like throughput? This man’s one simple trick can track actual database throughput; DBAs hate him! Everybody Knows Let’s take a look […]
Maintaining feature branches and submitting patches with Git
/0 Comments/in Eisentraut's PlanetPostgreSQL /by Peter EisentrautI have developed a particular Git workflow for maintaining PostgreSQL feature branches and submitting patches to the pgsql-hackers mailing list and commit fests. Perhaps it’s also useful to others. This workflow is useful for features that take a long time to develop, will be submitted for review several times, and will require a significant amount of changes over time. […]
PG Phriday: PgBouncer or Bust
/4 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasWhat is the role of PgBouncer in a Postgres High Availability stack? What even is PgBouncer at the end of the day? Is it a glorified traffic cop, or an integral component critical to the long-term survival of a Postgres deployment? When we talk about Postgres High Availability, a lot of terms might spring to […]
Sequential UUID Generators on SSD
/4 Comments/in 2ndQuadrant, Tomas' PlanetPostgreSQL /by Tomas VondraAfter I shared the sequential UUID benchmarks a couple of weeks ago, one of the points raised in feedback was the choice of the storage space. I’ve intentionally used a fairly weak storage system (RAID10 on three 7.2k SATA drives) because I wanted to demonstrate the benefits. But a couple of readers suggested using SSDs might significantly reduce […]
Webinar: pglogical and Postgres-BDR Update [Follow Up]
/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL /by Liaqat AndrabiSince the release of v3, Postgres-BDR has evolved into the go-to clustering technology built specially for businesses that require geographically distributed databases with multiple masters. To get an update on Postgres-BDR’s development, new features, and future roadmap, 2ndQuadrant held the pglogical and Postgres-BDR Update webinar as part of its PostgreSQL webinar series. The webinar was […]