PostgreSQL Archives - 2ndQuadrant

Posts

Webinar: Being Committed – A Review of Transaction Control Statements 3/3 [Follow Up]

August 6, 2020/0 Comments/in Webinars /by Adnan Nazar

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 […]

PostgreSQL 13: Don’t let slots kill your primary

July 30, 2020/0 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL 13 /by Álvaro Herrera

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.

Webinar: Being Committed – A Review of Transaction Control Statements 2/3 [Follow Up]

July 30, 2020/0 Comments/in Webinars /by Adnan Nazar

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 […]

Unicode normalization in PostgreSQL 13

July 23, 2020/3 Comments/in Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut

Unicode equivalence Unicode is a complicated beast. One of its numerous peculiar features is that different sequences of codepoints can be equal. This is not the case in legacy encodings. In LATIN1, for instance, the only thing that is equal to ‘a’ is ‘a’ and the only thing that is equal to ‘ä’ is ‘ä’. […]

Webinar: Being Committed – A Review of Transaction Control Statements 1/3 [Follow Up]

July 23, 2020/0 Comments/in Webinars /by Adnan Nazar

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. We will discover this feature in three sessions. First of the three sessions was conducted by Gianni Ciolli, Head of Professional Services at 2ndQuadrant. The session covered: […]

How to Monitor PostgreSQL 12 Performance with OmniDB – Part 2

July 21, 2020/0 Comments/in 2ndQuadrant, PostgreSQL, Sadeq's PlanetPostgreSQL, Technology /by Sadequl Hussain

In a previous article of this series, we created a two-node PostgreSQL 12 cluster in the AWS cloud. We also installed and configured 2ndQuadrant OmniDB in a third node. The image below shows the architecture: We could connect to both the primary and the standby node from OmniDB’s web-based user interface. We then restored a […]

Machine‌ ‌Learning‌ ‌with‌ ‌2UDA‌ ‌-‌ ‌PostgreSQL‌ ‌and‌ ‌ Orange‌ ‌-‌ ‌Concluding‌ ‌the‌ ‌series‌

July 17, 2020/0 Comments/in 2ndQuadrant, Seemab's PlanetPostgreSQL /by Semab Tariq

In this blog series, we have covered the following machine learning models to utilize Machine Learning capabilities with 2UDA. KNN SVM Random Forest Tree Logistic Regression AdaBoost Neural Network Now we are bringing you a recap of this blog series in order to summarize the results we obtained through these models in a single post. […]

Barman Cloud – Part 2: Cloud Backup

July 16, 2020/0 Comments/in 2ndQuadrant, Anna's PlanetPostgreSQL, Barman, DevOps, PostgreSQL /by Anna Bellandi

In the first part of this blog, Jonathan explained how the barman-wal-archive command works. Now, assuming you followed those instructions, you have a properly configured PostgreSQL instance up and running. In this second part, I will show you how the barman-cloud-backup command works.

Fireside Chat: BDR – Advanced Clustering & Scaling for PostgreSQL [Follow Up]

July 10, 2020/0 Comments/in Webinars /by Bilal Ibrar

BDR from 2ndQuadrant presents true high availability for mission critical databases running on PostgreSQL across various industry verticals such as financial services, telecommunications, and more. In order to explore BDR and its features in detail, 2ndQuadrant arranged a live Fireside Chat session on “BDR – Advanced Clustering & Scaling for PostgreSQL”. Guest: Simon Riggs, CEO […]

Migration to PostgreSQL [Webinar]

July 8, 2020/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat Andrabi

Among the many reasons to Migrate to PostgreSQL, dedicated support and seamless transition are key drivers for a business considering migration. Being open-source software, PostgreSQL provides a highly reliable, stable, scalable, and secure database migration, keeping in mind the unique needs of every business. Migration to PostgreSQL, however, can still be an extensive process as […]