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 usability improvements. In particular bdr_init_copy, the pg_basebackup-based node bring-up tool, is significantly improved in this update. This release also updates the BDR-patched version of PostgreSQL […]
Tablesample and Other Methods for Getting Random Tuples
/0 Comments/in 2ndQuadrant, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin YildirimPostgreSQL’s TABLESAMPLE brings a few more advantages compared to other traditional ways for getting random tuples.
Working towards Postgres-XL 9.5
/25 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL, PostgreSQL /by Pavan DeolaseeIt’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 scalable platform for OLTP and Business Intelligence. The current release of Postgres-XL is based on PostgreSQL 9.2, so it lacks all the improvements made to […]
What’s New in PgBouncer 1.6
/7 Comments/in Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin YildirimPgBouncer 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 PgBouncer.
Tablesample In PostgreSQL 9.5
/0 Comments/in Featured, Gulcin's PlanetPostgreSQL /by Gulcin YildirimPostgreSQL 9.5 introduces support for TABLESAMPLE, an SQL SELECT clause that returns a random sample from a table.
BDR 0.9.2 and BDR-PostgreSQL 9.4.4 released
/2 Comments/in Craig's PlanetPostgreSQL /by craig.ringerVersion 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 usability improvements. In particular bdr_init_copy, the pg_basebackup-based node bring-up tool, is significantly improved in this update. This release also updates the BDR-patched version of PostgreSQL […]
Why should you learn PostgreSQL?
/1 Comment/in PostgreSQL /by 2ndQuadrant PressA 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 question. It gives us both a direction to send us on our way and an expected destination. Without a clear path to follow, our brains […]
The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4
/0 Comments/in Featured, Giuseppe's PlanetPostgreSQL /by 2ndQuadrant PressPostgreSQL 9.4 extends the SQL standard by inserting two new clauses that facilitate many operations required during the development of applications: the WITHIN GROUP and FILTER clauses.
PostgreSQL 9.5: IMPORT FOREIGN SCHEMA
/6 Comments/in Giulio's PlanetPostgreSQL /by Giulio CalacociThe 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 to import a schema from a remote database, using Foreign Data Wrapper and the IMPORT FOREIGN SCHEMA command.
PostgreSQL anti-patterns: Unnecessary json/hstore dynamic columns
/40 Comments/in Craig's PlanetPostgreSQL /by craig.ringerPostgreSQL has json support – but you shouldn’t use it for the great majority of what you’re doing. This goes for hstore too, and the new jsonb type. These types are useful tools where they’re needed, but should not be your first choice when modelling your data in PostgreSQL, as it’ll make querying and manipulating […]
Automating Barman with Puppet: it2ndq/barman (part three)
/1 Comment/in Francesco's PlanetPostgreSQL /by Francesco CanovaiIn the second part of the Automating Barman with Puppet series we configured, via Puppet, two virtual machines: a PostgreSQL server and a Barman server to back it up. However, human intervention was required to perform the SSH key exchange and most of the manifest was written to allow the servers to access each other. […]