postgres-xl Archives - Page 2 of 2 - 2ndQuadrant

Posts

Postgres-XL 9.5R1Beta2 Released!

March 30, 2016/0 Comments/in Pavan's PlanetPostgreSQL /by Pavan Deolasee

The Postgres-XL 9.5R1Beta2 release went out yesterday. It’s another step forward to have a stable 9.5 release sometime very soon. A few key enhancements from the last beta release are captured in this blog. For the full list, I would recommend to read the release notes. Support for binary data transfer for JDBC and libpq If […]

Sharding: Bringing back Postgres-XL technology into core PostgreSQL

March 15, 2016/4 Comments/in Pavan's PlanetPostgreSQL /by Pavan Deolasee

Sharding or horizontal scalability is a popular topic, discussed widely on PostgreSQL mailing lists these days. When we started the Postgres-XC project back in 2010, not everyone was convinced that we need a multi-node PostgreSQL cluster that scales with increasing demand. Even more likely, we, the PostgreSQL community, were skeptical about whether we have enough […]

Postgres-XL 9.5R1Beta1 is here!

February 18, 2016/1 Comment/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan Deolasee

I’m extremely pleased to see that after months of efforts and contributions by different people around the world, Postgres-XL 9.5 R1 Beta1 has finally arrived. This release is significantly better, in all respects such as performance, stability and high availability, as compared to the past release. Enormous amount of work has gone into PostgreSQL in the […]

Looking forward to PGDay India 2016

February 14, 2016/1 Comment/in Pavan's PlanetPostgreSQL /by Pavan Deolasee

With just couple of weeks to go for PGDay India, I’m quite excited about the upcoming PostgreSQL conference at Bangalore on 26th February, 2016. This is going to be the biggest ever conglomeration of users, developers and companies interested in PostgreSQL in India. This is also by far the largest PostgreSQL conference in terms of number […]

Postgres-XL: Dealing with read-only transactions

February 12, 2016/3 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan Deolasee

One of the problems with Postgres-XL 9.2 is that it assigns a global transaction identifier (GXID) for every transaction that is started in the cluster. Since its hard for the system to know if a transaction is read-only or not (remember, even SELECT queries can do write activities), Postgres-XL would always assign a GXID and send […]

Performance of Sequences and Serials in Postgres-XL

January 7, 2016/7 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL, PostgreSQL /by Pavan Deolasee

In Postgres-XL, sequences are maintained at the Global Transaction Manager (GTM) to ensure that they are assigned non-conflicting values when they are incremented from multiple nodes. This adds significant overhead for a query doing thousands of INSERTs in a table with a serial column, incrementing sequence one at a time and making a network roundtrip […]

Benchmarking Postgres-XL

November 9, 2015/5 Comments/in 2ndQuadrant, Featured, Pavan's PlanetPostgreSQL, PostgreSQL /by Pavan Deolasee

As you may have noted from my previous blog, the last few months were busy in getting Postgres-XL up-to-date with the latest 9.5 release of PostgreSQL. Once we had a reasonably stable version of Postgres-XL 9.5, we shifted our attention to measure performance of this brand new version of Postgres-XL. Our choice of the benchmark […]

Testing Postgres-XL with DBT-3

October 8, 2015/6 Comments/in Mark's PlanetPostgreSQL /by Mark Wong

As people have been working on merging Postgres-XL with the PostgreSQL 9.5 branch, I’ve been trying out Postgres-XL’s ability to run a decision support-like workload. The DBT-3 test kit, originally developed at the OSDL as a TPC-H derivative, has some new changes so that it can run against Postgres-XL. I’ll describe how to use DBT-3 […]

Working towards Postgres-XL 9.5

August 26, 2015/25 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL, PostgreSQL /by Pavan Deolasee

It’s been busy few months as we work towards merging Postgres-XL with the latest and greatest release of PostgreSQL. Postgres-XL is an open source fork of PostgreSQL that provides a scalable platform for OLTP and Business Intelligence. The current release of Postgres-XL is based on PostgreSQL 9.2, so it lacks all the improvements made to […]

2ndQuadrant is now part of EDB