postgres Archives - Page 3 of 11 - 2ndQuadrant

Posts

PostgreSQL Meltdown Benchmarks

March 4, 2018/1 Comment/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

Two serious security vulnerabilities (code named Meltdown and Spectre) were revealed a couple of weeks ago. Initial tests suggested the performance impact of mitigations (added in the kernel) might be up to ~30% for some workloads, depending on the syscall rate. Those early estimates had to be done quickly, and so were based on limited […]

Webinar: Introduction to JSON data types in PostgreSQL [Follow Up]

December 19, 2017/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat Andrabi

On 12-Dec-2017, 2ndQuadrant held the first in a series of PostgreSQL webinars. The session was conducted by Andrew Dunstan, Principal Contributor of JSON functionality to PostgreSQL and Senior Developer & PostgreSQL Committer at 2ndQuadrant. As promised, the recording of the Webinar is now available. Those who couldn’t make it to the live session, can now view Introduction […]

Kanban & devops culture at 2ndQuadrant – Part 3

August 4, 2017/0 Comments/in DevOps, Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

In Part 3 of this series (here are Part 1 and Part 2), I would like to demonstrate how the development of a new feature for Barman would flow through the Kanban board.

Barman 2.2 and the magic of parallel copy

July 18, 2017/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

Barman 2.2 introduces support for parallel copy, by improving performance of both backup and recovery operations in your PostgreSQL disaster recovery solution.

Kanban & devops culture at 2ndQuadrant – Part 2

June 8, 2017/0 Comments/in DevOps /by Gabriele Bartolini

In Part 2 of this series, we will continue our journey within the developmental dynamics of the Barman open source project for PostgreSQL database backup and disaster recovery. After providing a small introduction to devops and Kanban in Part 1, let’s focus on the basic element of our daily management: The Boards.

Kanban & devops culture at 2ndQuadrant – Part 1

May 25, 2017/0 Comments/in DevOps /by Gabriele Bartolini

We very often hear about devops culture, lean and agile methodologies, kanban, pair programming, peer review, testing, and many more; but how many of us could effectively put these things into practice?

Using the PostgreSQL TAP framework in extensions

April 10, 2017/3 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

Support for using the TAP protocol to run extended regression tests was added to PostgreSQL back in 9.4 with the adoption of Perl’s prove tool and Test::More to test initdb, pg_basebackup, etc. Since then the TAP-based tests have been greatly expanded, particularly with the advent of the src/test/recovery tests and the PostgresNode module in PostgreSQL […]

Inserting JSONB data in PostgreSQL 9.6

January 26, 2017/0 Comments/in Rubens' PlanetPostgreSQL /by Rubens Souza

The jsonb_insert function brought in with PostgreSQL 9.6 gives more control when inserting new values into a jsonb array and/or new keys into a jsonb object. This article introduces this new function together with some examples.

Barman 2.1 and the new –archive option

January 9, 2017/0 Comments/in Giulio's PlanetPostgreSQL /by Giulio Calacoci

Barman 2.1 Version 2.1 of Barman, backup and recovery manager for PostgreSQL, was released Thursday, Jan. 5. The new release, along with several bugfixes, introduces preliminary support for the upcoming PostgreSQL 10, and adds the –archive option to the switch-xlog command. switch-xlog –archive The new –archive option is especially useful when setting up a new […]

PGDay.IT 2016 in Prato, Italy

December 21, 2016/0 Comments/in 2ndQuadrant, Jonathan's PlanetPostgreSQL /by Jonathan Battiato

This year, the ITPUG (Italian Postgres User Group) organized PGDay in Prato, my hometown and city where the association was born, although most of the members are from outside of the Tuscany region. It was my pleasure to contribute to the community by sharing my professional experience. I gave a talk about PostgreSQL on Network File System, […]

2ndQuadrant is now part of EDB