Schedule for PGDay UK 2017

Talk Description

The upcoming version of PostgreSQL will be 10, and by now we are well past feature freeze and there are only bug fixes remaining before the release is ready. This talk will take a look at some of the things that are available in what will eventually become PostgreSQL 10.

Talk Description

OpenStack is rapidly gaining popularity with businesses as they realise the benefits of a private cloud architecture. In this talk I'll describe some of the common components of OpenStack deployments, how they can affect Postgres servers, and how we might best utilise some of the features they offer when deploying Postgres, including:

- Different configurations for the Nova compute service
- Use of the Cinder block store
- Virtual networking options with Neutron
- WAL archiving with the Swift object store

Talk Description

Managing your own PostgreSQL servers is sometimes a burden your business does not want. In this talk we will provide an overview of some of the public cloud offerings available for hosted PostgreSQL and discuss a number of strategies for migrating your databases with a minimum of downtime.

Talk Description

"I have been involved in a project that uses MongoDB as the backend for about 6 months now. After using MongoDB, there are things I began to appreciate about PostgreSQL. Things that I have taken for granted and I missed them after using MongoDB. It's the little things that makes PostgreSQL so robust and mature."

Talk Description

Business intelligence and analytics is the core of any great company and Transferwise is not an exception.

The talk will start with a brief history on the legacy analytics implemented with MySQL and how we scaled up the performance using PostgreSQL. In order to get fresh data from the core MySQL databases in real time we used a modified version of pg_chameleon which also obfuscated the PII data.

The talk will also cover the challenges and the lesson learned by the developers and analysts when bridging MySQL with PostgreSQL.

Talk Description

At GoCardless, we use Postgres as the primary store for data that matters - records of merchants, customers and payments.

As a payments API, it's important to our users that we maintain a high level of uptime. At the same time, we believe that performing upgrades is an important reality of running software in production - databases included. Even the most stable software has critical bugs from time to time, and you have to deploy patches.

When it came to Postgres, we found ourselves caught between our desire to minimise downtime and our need to keep our software stack up-to-date. Postgres doesn't ship with all the machinery you need to do zero-downtime upgrades, so we knew we had work to do.

In the talk, we'll look at the problems faced when trying to upgrade Postgres without downtime, and explore our approach to building automation to upgrade Postgres without the apps noticing.

Talk Description

This talk is an overview on Parallel Queries, introduced in the latest release of PostgreSQL.

This feature is still being developed, and new capabilities will be added in the next releases. Nevertheless, the current implementation is already rather useful, and we will show realistic examples running on PostgreSQL 9.6.

We will also describe the architecture of Parallel Queries, the new node types introduced, and how parallel aggregates work. This will lead to a discussion on which kinds of queries can benefit more from this feature.

We will also briefly discuss massively parallel query with Postgres-XL.

Talk Description

Over the last few years, PostgreSQL had more options for scaling vertically and horizontally. In this talk, I will give detailed information about the scaling options in PostgreSQL, with the built-in ones and the 3rd party solutions.

Talk Description

Presentation of an investigation into how Python's RDFLib and SQLAlchemy can be used to leverage PostgreSQL's capabilities to provide a persistent storage back-end for Graphs, and become the elusive practical RDF triple store for the Semantic Web (or simply help you export your data to someone who's expecting RDF)!

Talk Description

Direct from the trenches feedback, covering a range of hands-on experiences relating to adoption, migration, security, robustness and performance of PostgreSQL.

Talk Description

Various changes and improvements in physical and logical replication in 9.6, 10, with in-depth discussion of logical replication and a live demo of PostgreSQL 10 features for replication monitoring and logical replication in action.