Skip to content

My picks for Postgres Open SV 2018 !

Postgres Open SV 2018 is less than two weeks away now, and I'll speak there as well.

Many people, including me, are flying overseas to attend this great conference, so please hurry up and register before the tickets run out!

Life is hard when there are a lot of talks in parallel, but still I picked up some interesting talks that I want to attend: Continue reading "My picks for Postgres Open SV 2018 !"

PGDay Comes to Amsterdam on July 12th

Thought it would be good to make everyone aware that PGDay is coming to Amsterdam for the first time on July 12th and I’m delighted to say I will be there helping to host the day, as well as presenting on Write-Ahead Log (WAL). If you want to find out more you can go to this link and find out more. The event will be at the Tobacco Theatre in Amsterdam, which also happens to be one of my favourite cities.

Having just come back from Postgres Vision 2018 and attending a number of Postgres community events across Europe it is great to see how Postgres really is everywhere now in the enterprise database world.

The event in Amsterdam is going to be a great opportunity for existing Postgres users and those developers looking to explore the technology to hear from some of the leading experts in the field. Bruce Momjian, co-founder of the PostgreSQL Global Development Group, will be keynoting and there will be a wide variety of speakers including Jan Karremans, Oleksi Kliukin, Daniel Westerman, Stefanie Stoelting, as well as Ilya Kosmodemiansky, Jeroen de Graaff, Hans-Jürgen Schönig and Andreas Scherbaum.

All of these speakers have been working with PostgreSQL for a long time and have some insights into upcoming releases, as well as key developments in the project. We will be covering major topics such as PostgreSQL in the Cloud, migrating from Oracle and the upcoming Postgres 11 release, but we will also be delving into more technical topics. There will be presentations on pgBackRest, the ability of pg_chameleon to create replicas from MySQL to PostgreSQL and PostgreSQL as a data integration tool.

The sponsors for the event cover a wide range of expertise and understanding of PostgreSQL, so there will be opportunities to understand how they can help you deploy the technology efficiently. The sponsors include Quest Software, EnterpriseDB, 12Apollos, Kangaroot, Nibble-IT, 2nd Quadrant, GITC Pro and Cybertec.

As a member of the talk committee I witnessed first-hand how seriously everyone took their responsibilities when assessing the talk submissions. So on behalf of everyone in the community I want to say thank you to my fellow committee members Robert Ivens, Magnus Hagander, Andreas Scherbaum and Anja van Elteren.

I’m sure it’s going to be an informative event, so if you can join us please do come along to hear how PostgreSQL is shaking up the market and providing enterprises with the only credible alternative to today’s traditional commercial relational databases.

Announcing PostgreSQL SLES RPM Repository!

I am proud to announce the new and shiny PostgreSQL RPM repository for SLES 12: This is a part of EnterpriseDB's contribution to the community: EDB provided hardware, and let me use my time for these packages.

The new repo contains (almost) all of the packages that the PostgreSQL YUM repository has. Currently. we support PostgreSQL 10, 9.6 and 9.5, along with more than a hundred packages on each version.

I also wrote a basic howto for using PostgreSQL RPMs on SLES, so please read it first, if you are not that familiar to SLES.


London PostgreSQL Users Group: First meetup

We recently formed a new London PostgreSQL Users Group recently, and our first meetup is on Oct 5th.


In this first meetup, we have two talks:

- I will speak about the new and exciting features in PostgreSQL 10.

- Ivan Novick will speak about "Merging PostgreSQL into Greenplum v5 and future roadmap"

Each session will be 45 mins.


2nd floor, The Warehouse, The Bower, 211 Old Street EC1V 9NR, London

Please click here for Google Maps link.


Please follow us on Twitter.

Lots of changes at

Over the last few weeks, I spent some time to shuffle the PostgreSQL YUM repo a bit, before 9.6 is released. With the help of Magnus, we also made some changes on the server side, so I will summarize all changes in this post:

- Direct downloads from are now redirected to All RPMs are already being served from over the last year, so it is the time to redirect it. Please change your scripts to use .

- Starting Sep 25th, started speaking https. I updated all repo packages to point to the new URL for GPG checks. Website will be HTTPS only in near future. Please update repo RPMs!

- Starting Sep 25th, we started keeping only last n-2 minor releases in the repo. This means, when there is new release available, we will delete n-3th one. This is a policy to keep the repo clean. This does not apply for PostgreSQL major releases.

* We started serving delta RPMs for all distros except RHEL 5. This will save great bandwidth.

Please let us know if you have more questions, via mailing list:


PostgreSQL is dropping native Windows port, use RPMs.

Important stuff is going on in IT industry nowadays.

Given that Microsot is merging bash shell into Windows, PostgreSQL is considering to drop native Windows port.

Core Team member Josh Berkus sent an email to PostgreSQL hackers mailing list the other day, and proposed dropping the Windows port.

Unsurprisingly, he got great support from Tom Lane. Tom wrote a response. Here is a quote from his email:

"Really? Good. I just committed my very last Windows-related fix, then. Somebody else can deal with it."

There are some unofficial reports about Tom that he opened up a champagne bottle right after this email, but I cannot disclosure my source.

Josh was also backed up by Joe Conway, who authors the famous PL/R extension:

"I would surely love to dump Windows support in PL/R as it is a major league PITA. It is probably an understatement to say that over the last 10+ years, 95+% of the time I have spent maintaining and supporting PL/R has been directly attributable to the Windows port."

However, users from the field acted promptly, looking for alternatives to run PostgreSQL on Windows.

After discussing with other team members, we, as the PostgreSQL YUM repo developers, decided to add Windows support to our RPMs. We contacted Microsoft, and Microsoft kindly provided us a tech preview of the bash environment. After some hacks, here are the results:

$ rpm -ivh postgresql95-libs-9.5.7-1PGDG.Windows2017.x86_64.rpm

command works as expected.

Please stay tuned, until we release all the remaining RPMs for Windows.

9.6, or 10.0?

Even though PostgreSQL 9.5 was released not too long ago, we are almost getting closer towards the feature freeze for 9.6.

When Windows support and PITR capabilities were added to 7.5, the community decided to change the major version to 8.0, as it represents a significant changes at those times. Similar thing happened at 8.5 development cycle: We now had in core replication, and it was released as 9.0.

Now, as 9.6 is coming closer, I seriously think that we should release 10.0, not 9.6 (I've been ranting about this on my Twitter account for a while). Following the commit of Parallel sequential scan , subsequent commits for:

- Parallel Joins
- Parallel Aggregation

increased parallelism features.

Another big infrastructure change is Tom's patch on "Making the upper part of the planner work by generating and comparing Paths."

Apart from these, following the commit that changes the VM file format, another commit titled
Don't vacuum all-frozen pages will help us to deploy PostgreSQL in some environments that we could not do before, I think.

To keep it short, I think that these infrastructural changes should result in a .0 release, as we did before.

What do you think?

Installing and running PostgreSQL 9.5 using RPMs on RHEL/CentOS/Scientific Linux/Oracle Linux and Fedora

PostgreSQL 9.5 was released recently. We released PostgreSQL 9.5 RPMs at the same day.

In this blog post, I am going to write you how to install PostgreSQL 9.5 on RHEL/CentOS/Scientific Linux/Oracle Linux 6 and 7 , Fedora 22 and 23. Continue reading "Installing and running PostgreSQL 9.5 using RPMs on RHEL/CentOS/Scientific Linux/Oracle Linux and Fedora"

PostgreSQL YUM repo receives largest update set, ever.

Today, the PostgreSQL Global Development Group announced new minor releases for all supported version: 9.5.1, 9.4.6, 9.3.11, 9.2.15 and 9.1.20. As usual, RPMs are out, too:

Since the last set of updates, I have been working hard with other members in the community for shuffling the repo a bit, towards an aim for better and easier maintenance.

Below is the list of today's update set. They all include the latest versions of each software as of today:


Please let us know if you encounter any issues with the packaging.


Please join us for testing 9.6!

PostgreSQL 9.6 is coming with some great features, and one of them is parallelism. Robert Haas committed a series of commits about it, and recently he added support for both parallel sequential scan and parallel joins:

To help people test all of upcoming features, I will push regularly updated RPMs for the following platforms to the PostgreSQL YUM repository:

- RHEL/CentOS/Scientific Linux/Oracle Enterprise Linux 6 and 7
- Fedora 23 and 22

Please note that these packages are built using the official daily tarball. The package name contains the date that the package is built on.

More information can be found here.

These packages are for crash testing only, never ever intended for production or even beta or alpha usage.

Please report any PostgreSQL bugs to pgsql-bugs(at)PostgreSQL(dot)org

Mark your calendars: May 9 2015, PGDay.TR in Istanbul!

Turkish PostgreSQL Users' and Developer's Association is organizing 4th PGDay.TR on May 9, 2015 at Istanbul. Dave Page, one of the community leaders, will be giving the keynote.

This year, we are going to have 1 full English track along with 2 Turkish tracks, so if you are close to Istanbul, please join us for a wonderful city, event and fun!

We are also looking for sponsors for this great event. Please email to for details.

See you in Istanbul!

Conference website: