PostgreSQL10 Archives - Page 2 of 2 - 2ndQuadrant

Posts

PG Phriday: Crazy Correlated Column Crusade

July 14, 2017/4 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

For a long time, the Postgres query planner has sported a huge blinking neon blind-spot that frustrated and enraged DBAs throughout the universe to a level just shy of murderous frenzy. How is this even possible? What terrible lurking horror could elicit such a visceral response from probably the most boring and straight-laced people ever […]

News and Roadmap from Postgres-XL 10

July 5, 2017/6 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan Deolasee

We expect Postgres-XL 10 to be released in the next few months, with the new features of partitioning and logical replication. You’ll be able to load Postgres-XL directly from PostgreSQL. For the first time, you’ll be able to run massively parallel queries both across the datanodes and within the datanodes to give huge performance gains. […]

More robust collations with ICU support in PostgreSQL 10

May 22, 2017/20 Comments/in Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut

In this article, I want to introduce the ICU support in PostgreSQL, which I have worked on for PostgreSQL version 10, to appear later this year. Sorting Sorting is an important functionality of a database system. First, users generally want to see data sorted. Any query result that contains more than one row and is […]

Logical Replication in PostgreSQL 10

April 28, 2017/37 Comments/in Petr's PlanetPostgreSQL /by Petr Jelinek

PostgreSQL 10 is getting close to its first beta release and it will include the initial support for logical replication, which is was written primarily by me and committed by my colleague Peter Eisentraut, and is internally based on the work 2ndQuadrant did on pglogical (even though the user interface is somewhat different). I’d like […]

PostgreSQL 10 identity columns explained

April 24, 2017/27 Comments/in Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut

Traceable commit for PostgreSQL 10

April 5, 2017/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

PostgreSQL 10 now supports finding out the status of a recent transaction for recovery after network connection loss or crash.

XMLTABLE in PostgreSQL

March 8, 2017/14 Comments/in Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro Herrera

I just committed a patch by Pavel Stěhule that adds the XMLTABLE functionality to PostgreSQL 10. XMLTABLE is a very useful feature dictated by the SQL/XML standard, that lets you turn your XML data into relational form, so that you can mix it with the rest of your relational data. This feature has many uses; keep reading for […]

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.

2ndQuadrant is now part of EDB

Posts

PG Phriday: Crazy Correlated Column Crusade

News and Roadmap from Postgres-XL 10

More robust collations with ICU support in PostgreSQL 10

Logical Replication in PostgreSQL 10

PostgreSQL 10 identity columns explained

Traceable commit for PostgreSQL 10

XMLTABLE in PostgreSQL

PostgreSQL 10 Roadmap

Support & Services

Products

Postgres Learning Center

About Us