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...
The release of PostgreSQL 9.5 is imminent so the time has come to analyse what’s new in this latest version. A very interesting feature of version 9.5 is the ability...
