Posts by: simon.riggs

Dataloss at GitLab

GitLab, thanks for using PostgreSQL 9.6 and its replication and backup facilities. We’re sorry that you lost your database: https://about.gitlab.com/2017/02/01/gitlab-dot-com-database-incident/ Thank you for posting this publicly to allow us to comment on this for your postmortem analysis. I’m very happy that you monitor Replication Lag, that is good. Replication lag of 4GB is at times…

What does pg_start_backup() do?

Reading mailing lists can damage your health, as I recently discovered on the PostgreSQL Performance list where backup was being discussed. First off, don’t read blogs for finding out critical pieces of info. Read the docs because they are accurate, fully reviewed and well maintained. I should add that I was the initial author of…

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…

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…

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…

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

Highlights of PGconf.EU

Wed 2 Nov Michiel Toneman from Adyen kicked things off with a keynote mentioning how Adyen have been using PostgreSQL for the past 9 years. I wasn’t aware Michiel was speaking, though I was very happy that he mentioned 2ndQuadrant’s extensive support of their multi-Terabyte PostgreSQL installations. https://www.postgresql.eu/events/schedule/pgconfeu2016/session/1419-building-a-unicorn-on-an-elephant/ I spent most of the first day…

Cool Runnings

In an earlier post I commented on a post by Evan Klitzke on his reasons for recommending a move from PostgreSQL to MySQL. The summary was that the technical details were incorrect, apart from two points. This post returns to those points to discuss what we’ve done about them. 1. When one indexed column is…

PostgreSQL 9.1 End of Life

As you may have seen, PostgreSQL 9.1 has now reached its End of Life. That means the last maintenance update of 9.1 will be in November 2016. PostgreSQL 9.6 is currently due out in September 2016, so you have a chance to move from PostgreSQL 9.1 to PostgreSQL 9.6. Supported upgrade choices are pg_upgrade pg_dump…

123