PostgreSQL 10 Archives - 2ndQuadrant

Posts

Here’s How You Can Run OmniDB On Postgres10 [VIDEO]

November 8, 2017/0 Comments/in Liaqat's PlanetPostgreSQL, OmniDB, PostgreSQL /by Liaqat Andrabi

OmniDB is an open source web tool designed specifically for managing relational databases with focus on simplicity and user interaction, but at the same time be fast, powerful and light on memory. OmniDB, at the moment, supports several different relational database systems such as PostgreSQL. The latest release of OmniDB, version 2.3.0, has introduced ‘Debugger […]

PG Phriday: pglogical and Postgres 10 Partitions

September 22, 2017/5 Comments/in pglogical, Shaun's PlanetPostgreSQL /by Shaun Thomas

During the Postgres Open 2017 conference in San Francisco, someone came to the 2ndQuadrant booth and struck up a conversation with me. During our shameless geeking out over database mechanics, he asked me if pglogical supported the new Postgres 10 partitions. Given my noted expertise in all things Postgres, I answered in the appropriate manner: […]

The Barman is ready for PostgreSQL 10

September 6, 2017/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

Today our Devops team at 2ndQuadrant, led by my dear friend and trusted colleague Marco Nenciarini, released version 2.3 of Barman.

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/35 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/24 Comments/in Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut

For PostgreSQL 10, I have worked on a feature called “identity columns”. Depesz already wrote a blog post about it and showed that it works pretty much like serial columns: CREATE TABLE test_old ( id serial PRIMARY KEY, payload text ); INSERT INTO test_old (payload) VALUES (‘a’), (‘b’), (‘c’) RETURNING *; and CREATE TABLE […]

Read 2ndQuadrant’s response to the COVID – 19 emergency here

Posts

Here’s How You Can Run OmniDB On Postgres10 [VIDEO]

PG Phriday: pglogical and Postgres 10 Partitions

The Barman is ready for PostgreSQL 10

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

Support & Services

Products

Postgres Learning Center

About Us