CHAR (16) – Another conference on the horizon but with a focus on business

The PostgreSQL user community is becoming spoilt with a choice of excellent events organized by both local user groups and commercial organizations supporting the Postgre ...

More ‘POWER’ for PostgreSQL

Now Available! Debian and Ubuntu packages for Power Architecture. The official announcement was published last Friday, September 30, 2016: the PostgreSQL repository for D ...

Committed to the PostgreSQL Community, 2ndQuadrant Contributes to 9.6

The latest version of PostgreSQL 9.6 is planned to be released later today, bringing with it some much anticipated features and updates. As the most advanced open source ...

Back to the Future Pt. 2: How to use pg_rewind with PostgreSQL 9.5

In the previous blog article we have seen how pg_rewind works with a simple HA cluster, composed of a master node replicating to a standby. In this context, an eventual s ...

The Best Barman Ever

This is my (very) biased opinion, but I am ready to bet that once you try Barman 2.0 you’ll agree with me. Version 2.0 takes Barman to a new level, thanks to full ...

Back to the Future Pt. 1: Introduction to pg_rewind

Since PostgreSQL 9.5, pg_rewind has been able to make a former master follow up a promoted standby although, in the meantime, it proceeded with its own timeline. Consider ...

Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit

PostgreSQL is an awesome project and it evolves at an amazing rate. We’ll focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions with ...

PostgreSQL vs. Linux kernel versions

I’ve published multiple benchmarks comparing different PostgreSQL versions, as for example the performance archaeology talk (evaluating PostgreSQL 7.4 up to 9.4), a ...

Evolution of Fault Tolerance in PostgreSQL: Time Travel

PostgreSQL is an awesome project and it evolves at an amazing rate. We’ll focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions with ...

Speed up getting WAL files from Barman

Starting from Barman 1.6.1, PostgreSQL standby servers can rely on an “infinite” basin of WAL files and finally pre-fetch batches of WAL files in parallel fro ...

PostgreSQL’s Popularity Goes Up Again

Mirror mirror on the wall, Who is the fairest Database of all? A frequently asked question, certainly. DB-Engines recently announced it’s DBMS of the Year. Maybe the cool thing is that PostgreSQL is in 3rd Place. Yee-ha, an open source project is up there! Let’s look closely about what this means. PostgreSQL.org’s agreed response was…

PGDay.IT 2016 in Prato, Italy

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,…

CHAR16 Conf Panel Video

CHAR(16) Conference was a live conference in NYC held on 6 Dec 2016, focusing on Scalability for Business. The Speaker Panel was recorded, so you can find out what happened here: https://youtu.be/eLjBoZr4dTc (1 hour) Eric David Benari hosted an hour long “chat show” format, featuring Mason Sharp Petr Jelinek Peter Eisentraut Simon Riggs Jonathan Katz…

The PostgreSQL License – What Does It Mean For My Business?

When I talk to various people about PostgreSQL, based on where they are in the process of analyzing it, I get asked many similar questions. One of the most frequently asked questions is: What is the PostgreSQL licensing model? Here is my attempt to address this question from the perspective of what the PostgreSQL license…

CHAR(16) Scalability for Business

CHAR(16) Conference on Scalability for Business went very well in the heart of New York City. Hotel Pennsylvania was a great venue; convenient for travel and a great conference venue with coffee, food and evening drinks. Jonathan Katz was great as MC for the conference, while Eric David Benari did a great job of hosting the Speaker Panel…

Avoiding Disasters in New York

What to do when disaster strikes… (various topics) King Kong attacks! Lure up tall building and attack with biplanes Godzilla’s eggs hatch Team up with European Special Forces operative to escape, then call in airstrike on Madison Square Gardens Watch the Rangers lose at home (same as above) Global Warming descends quickly Stay holed up…

On the impact of full-page writes

While tweaking postgresql.conf, you might have noticed there’s an option called full_page_writes. The comment next to it says something about partial page writes, and people generally leave it set to on – which is a good thing, as I’ll explain later in this post. It’s however useful to understand what full page writes do, because…

PostgreSQL Meetup in Melbourne, Australia

If you live in the Melbourne area and you are passionate about PostgreSQL then don’t miss the chance to come to the Melbourne PostgreSQL Users Group Meetup this Monday, 21 November.

Basics of Tuning Checkpoints

On systems doing non-trivial number of writes, tuning checkpoints is crucial for getting good performance. Yet checkpoints are one of the areas where we often identify confusion and configuration issues, both on the community mailing lists and during performance tuning reviews for our customers. (The other one being autovacuum, discussed a few days ago by…

PostgreSQL Solution Architecture

Keynote at PgConf.EU was well attended. I have already written about my impressions of the conference here. PostgreSQL is becoming a complete solution architecture for data, based upon the capabilities to push and pull data to/from other datastores, including other types of datastore. A variety of components, large and small make up that full architecture,…

‹ Prev12345678Next ›Last »