PostgreSQL 9.4 for administrators (part one)

A two-part article to explain the main new features of PostgreSQL 9.4 for administrators

PostgreSQL 9.4 for administrators (part two)

A two-part article to explain the main new features of PostgreSQL 9.4 for administrators

NoSQL with PostgreSQL 9.4 and JSONB

The introduction of JSONB data type in PostgreSQL, definitely makes the “NoSQL” side of this relational DBMS come out

JSONB type performance in PostgreSQL 9.4

The 9.4 version of PostgreSQL introduces the JSONB data type, a specialised representation of the JSON data!

What’s new about Barman 1.4.0?

The 1.4.0 version of Barman adds new features such as incremental backup and automatic integration with pg_stat_archiver.

Automating Barman with Puppet: it2ndq/barman (part one)

How to automate Barman setup and configuration with Puppet and the it2ndq/barman module to backup a PostgreSQL server

Automating Barman with Puppet: it2ndq/barman (part two)

How to automate Barman setup and configuration with Puppet and the it2ndq/barman module to backup a PostgreSQL server (part two)

Automating Barman with Puppet: it2ndq/barman (part three)

How to automate Barman setup and configuration with Puppet and the it2ndq/barman module to backup a PostgreSQL server (part three)

PostgreSQL 9.5: IMPORT FOREIGN SCHEMA

In PostgreSQL 9.5 will be possible to import a complete schema from an external database, using Foreign Data Wrappers and IMPORT FOREIGN SCHEMA command.

The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4

PostgreSQL 9.4 extends the SQL standard by inserting two new clauses: the WITHIN GROUP and FILTER clauses.

What’s new in PgBouncer 1.6

The latest release of PgBouncer was announced on 1st of August 2015. In this blog post we’ll talk about the major new improvements of PgBouncer.

Tablesample In PostgreSQL 9.5

PostgreSQL 9.5 introduces support for TABLESAMPLE, an SQL SELECT clause that returns a random sample from a table.

Working towards Postgres-XL 9.5

It’s been busy few months as we work towards merging Postgres-XL with the latest and greatest release…

v6pgbouncer-slide

What’s New in PgBouncer 1.6

PgBouncer is lightweight connection pooler for PostgreSQL. The latest release of PgBouncer was announced on 1st of…

Alpha 2 for 2UDA released

So, the Alpha 2 for 2ndQuadrant’s Unified Data Analytics (or 2UDA) was released today. We have basically…

sampling-methods-slide

Tablesample In PostgreSQL 9.5

PostgreSQL 9.5 introduces support for TABLESAMPLE, an SQL SELECT clause that returns a random sample from a…

BDR 0.9.2 and BDR-PostgreSQL 9.4.4 released

Version 0.9.2 of the BDR (Bi-Directional Replication) extension for PosgreSQL has been released. This is a maintenance…

Why should you learn PostgreSQL?

A few weeks ago I asked one of my colleagues why I should learn PostgreSQL. Harald’s answer…

within-group-and-filter

The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4

PostgreSQL 9.4 extends the SQL standard by inserting two new clauses that facilitate many operations required during…

import-foreign-schema

PostgreSQL 9.5: IMPORT FOREIGN SCHEMA

The release of PostgreSQL 9.5 is imminent so the time has come to analyse what’s new in…

PostgreSQL anti-patterns: Unnecessary json/hstore dynamic columns

PostgreSQL has json support – but you shouldn’t use it for the great majority of what you’re…

robot-slide

Automating Barman with Puppet: it2ndq/barman (part three)

In the second part of the Automating Barman with Puppet series we configured, via Puppet, two virtual…

puppet-barman-part-2

Automating Barman with Puppet: it2ndq/barman (part two)

In the first part of this article we configured Vagrant to execute two Ubuntu 14.04 Trusty Tahr…

Dynamic SQL-level configuration for BDR 0.9.0

The BDR team has recently introduced support for dynamically adding new nodes to a BDR group from…

vagrant-barman

Automating Barman with Puppet: it2ndq/barman (part one)

This is not the first time that 2ndQuadrant has looked at Puppet. Gabriele Bartolini has already written an…

tazzine-barman-fondogrigio

What’s new about Barman 1.4.0?

The 1.4.0 version of Barman adds new features such as incremental backup and automatic integration with pg_stat_archiver…

slide-json-marco

JSONB type performance in PostgreSQL 9.4

The 9.4 version of PostgreSQL introduces the JSONB data type, a specialised representation of the JSON data,…

slide-json-giuseppe

NoSQL with PostgreSQL 9.4 and JSONB

The introduction of the JSONB data type in PostgreSQL, definitely makes the “NoSQ” side of this relational…

12345Next ›Last »