Simon's PlanetPostgreSQL Archives - Page 3 of 4 - 2ndQuadrant

PostgreSQL Solution Architecture

November 8, 2016/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

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

November 4, 2016/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

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. http://www.postgresql.eu/events/schedule/pgconfeu2016/session/1419-building-a-unicorn-on-an-elephant/ I spent most of the first day […]

Cool Runnings

October 3, 2016/2 Comments/in Simon's PlanetPostgreSQL /by Simon Riggs

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

September 5, 2016/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

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 […]

When to use Postgres-BDR or Postgres-XL?

August 25, 2016/1 Comment/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

The right answer is of course “Use PostgreSQL”. It’s the main distro and we want you to use that as often as possible. The Postgres-BDR and Postgres-XL projects are also fully open source projects, using the same copyright and licence as the main PostgreSQL project. So if you’re using PostgreSQL, they are also options to […]

Postgres-BDR: 2 Years in Production

August 18, 2016/1 Comment/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

Postgres-BDR has now reached 1.0 production status. Over the last 2 years, Postgres-BDR has been used daily for mission critical production systems. As you might imagine, it’s been improved by both bug fixes and feature enhancements that allow it to be used smoothly, so its mature, robust and feature-rich. The BDR Project introduced logical replication […]

PostgreSQL Solutions Roadmap

August 5, 2016/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

In a recent blog, I described features for PostgreSQL Core that we’ve been working on https://www.2ndquadrant.com/en/blog/postgresql-solutions-roadmap/ Many people have asked for a similar roadmap for BDR and Postgres-XL. I can confirm that both are under active development and in active use. Postgres-XL (link) XL 9.5 v1.2 is now available, with more updates coming. XL 9.6 […]

Thoughts on Uber’s List of Postgres Limitations

August 2, 2016/11 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

An Uber technical blog of July 2016 described the perception of “many Postgres limitations”. Regrettably, a number of important technical points are either not correct or not wholly correct because they overlook many optimizations in PostgreSQL that were added specifically to address the cases discussed. In most cases, those limitations were actually true in the […]

PostgreSQL 10 Roadmap

August 2, 2016/10 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

At the PostgreSQL developer meeting we discussed putting up everybody’s roadmap projects in one place: http://wiki.postgresql.org/wiki/PostgreSQL10_Roadmap.

Report from DatabaseCamp, NYC

July 18, 2016/0 Comments/in Featured, Simon's PlanetPostgreSQL /by Simon Riggs

Just got back from extended trip to Database.Camp – Sunday, July 10, 2016 – at the UN in NYC – Totally Free! Wide range of presentations from CTOs/CEOs from across the database software world, with about 200 attendees, slightly more people earlier in the day. Very happy to report we had 3 presentations covering different […]

2ndQuadrant is now part of EDB