As people have been working on merging Postgres-XL with the PostgreSQL 9.5 branch, I’ve been trying out Postgres-XL’s ability to run a decision support-like workload. The DBT-3 test kit, originally...
Barman 1.5.0 enhances the robustness and business continuity capabilities of PostgreSQL clusters, integrating the get-wal command with any standby server’s restore_command. In this blog article I will go over the...
Version 1.5.0 of Barman, Backup and Recovery Manager for PostgreSQL, has been released. Barman is now able to return upon request any available WAL file for a given server, allowing...
PostgreSQL’s TABLESAMPLE brings a few more advantages compared to other traditional ways for getting random tuples. TABLESAMPLE is a SQL SELECT clause and it provides two sampling methods which are...
It’s been busy few months as we work towards merging Postgres-XL with the latest and greatest release of PostgreSQL. Postgres-XL is an open source fork of PostgreSQL that provides a...
PgBouncer is a lightweight connection pooler for PostgreSQL. PgBouncer 1.6 was announced on the 1st of August 2015. In this blog post we’ll talk about the major new improvements in...
So, the Alpha 2 for 2ndQuadrant’s Unified Data Analytics (or 2UDA) was released today. We have basically repackaged the latest versions of PostgreSQL 9.5, Orange 3, & LibreOffice 5 in...
PostgreSQL 9.5 introduces support for TABLESAMPLE, an SQL SELECT clause that returns a random sample from a table. SQL:2003 defines two sampling methods: SYSTEM and BERNOULLI. The SYSTEM method uses...
Version 0.9.2 of the BDR (Bi-Directional Replication) extension for PosgreSQL has been released. This is a maintenance release in the current stable 0.9.x series, focused on bug fixes, stability and...
A few weeks ago I asked one of my colleagues why I should learn PostgreSQL. Harald’s answer was: “To start any new journey of learning, asking ‘why’ is an excellent...
