Pavan's PlanetPostgreSQL Archives - 2ndQuadrant

[Video] Power of Indexing in PostgreSQL

September 25, 2018/0 Comments/in Pavan's PlanetPostgreSQL, PostgreSQL /by Pavan Deolasee

The video of my presentation below walks you through ‘Indexing in PostgreSQL’ – a key component to database performance. This presentation covers the following topics: Various ways to access data in PostgreSQL Different types of indexes supported by PostgreSQL Internals of BTree and BRIN indexes Overview of GIN and GiST indexes How to find missing indexes […]

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

PGConf India 2017 – An Event to Remember

March 24, 2017/0 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan Deolasee

Yet another edition of PGConf India came to conclusion in early March. You may have noticed the change from PGDay to PGConf, which signals a much larger gathering of PostgreSQL enthusiasts, now and in future. What started as a small meet-up of like minded people 4 years back, has now grown into a 2-day conference […]

Looking forward to PGConf India 2017

February 21, 2017/0 Comments/in Pavan's PlanetPostgreSQL, PostgreSQL /by Pavan Deolasee

It has taken a lot of planning and efforts, but I’m happy to see that PGConf India 2017 is coming along very well and promises to be a great event. This is our third year in a row in Bengaluru, but there are many distinguishing factors that make this year stand out: For the first […]

Corruption in CREATE INDEX CONCURRENTLY

February 15, 2017/1 Comment/in Pavan's PlanetPostgreSQL /by Pavan Deolasee

Two weeks back we discovered an ancient bug in PostgreSQL which may cause index corruption when index is built via CREATE INDEX CONCURRENTLY (aka CIC). All supported releases of PostgreSQL are affected by this bug. The bug could be a source of index corruption reports that we receive from the field once in awhile. Now […]

Explaining CREATE INDEX CONCURRENTLY

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

This technical blog explains how CREATE INDEX CONCURRENTLY (CIC) works and how it manages to avoid locking the table from updates. A unique distinguishing factor of CIC is that it can build a new index on the table, without blocking it from updates/inserts/deletes. But even before that, let’s understand how Heap-Only-Tuple (HOT) works. It was […]

Postgres-XL Scalability for Loading Data

October 24, 2016/2 Comments/in Pavan's PlanetPostgreSQL /by Pavan Deolasee

In my last blog, we looked at the benchmark results from bulk load test for a Postgres-XL database cluster. Using a 16-datanode, 2-coordinator cluster, running on EC2 instances, we could easily clock 9M rows/sec or 3TB/hr of ingestion rate. That’s a significant number in itself. In this blog, we’ll see if the ingestion rate is […]

Load data in Postgres-XL at over 9M rows/sec

October 13, 2016/6 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan Deolasee

We are faced with this question: “What’s the ingestion rate of Postgres-XL?”, and I realised I don’t have a very good answer to that. Since recently we made some good improvements in this area, I was curious to know too. Well, I decided to benchmark. Hardware and Software For the tests, I used a Postgres-XL cluster running […]

How will Postgres-XL exploit the Parallel Query Capabilities of PostgreSQL 9.6?

October 6, 2016/0 Comments/in Pavan's PlanetPostgreSQL /by Pavan Deolasee

With PostgreSQL 9.6 now out, many of our users and customers are asking us about the plans for Postgres-XL 9.6. The new release of PostgreSQL implements some new features, especially around parallel query processing and many are interested to know when those capabilities will be available in Postgres-XL. Postgres-XL itself is a massively parallel processing system. […]

Postgres-XL 9.5r1.1 released

May 12, 2016/0 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan Deolasee

The Postgres-XL community has released a new version of the software, tagged as 9.5r1.1. This is a minor update to earlier 9.5r1 release, but contains some very important bug fixes. I would encourage everyone to immediately upgrade to this latest release. Being a minor release, you only need to download the latest sources from , […]