Schedule for PGDay UK 2017


Main Schedule

8:30 AM
Registration Opens
9:15 AM
Welcome & Introductions
9:30 AM
Speaker:
Magnus Hagander
A Look At The Elephant's Trunk - PostgreSQL 10

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.

Show / Hide Info
10:15 AM
Speaker:
Dave Page
PostgreSQL On OpenStack

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

Show / Hide Info
11:00 AM
Refreshment Break
11:30 AM
Speaker:
Mike Fowler
Hosted PostgreSQL

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.

Show / Hide Info
11:50 AM
Speaker:
Wei Shan
Things I Appreciate About PostgreSQL After Using MongoDB For 6 Months

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."

Show / Hide Info
12:10 PM
Speaker:
Federico Campoli
The Ninja Elephant, Scaling The Analytics Database In Transferwise

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.

Show / Hide Info
12:40 PM
Speaker:
Chris Sinjakli
Zero-downtime Postgres Upgrades

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.

Show / Hide Info
1:00 PM
Lunch
2:00 PM
Speaker:
Gianni Ciolli
Parallel Query

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.

Show / Hide Info
2:30 PM
Speaker:
Devrim Gunduz
Scale Your PostgreSQL

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.

Show / Hide Info
3:00 PM
Speaker:
Jimmy Angelakos
Using PostgreSQL As An RDF Graph Database

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)!

Show / Hide Info
3:30 PM
Refreshment Break
4:00 PM
Speaker:
Frederic Vander Elst
PostgreSQL at Experian

Talk Description

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

Show / Hide Info
4:30 PM
Speaker:
Simon Riggs
Replication In PostgreSQL 9.6, 10 And Beyond

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.


Show / Hide Info
5:15 PM
End of Programme - Closing Remarks
5:30 PM
Drinks Reception

Training Schedule

PostgreSQL Replication & Upgrades Course - 3rd July 2017


10:00 AM
PostgreSQL Replication & Upgrades by Simon Riggs & Petr Jelinek

PostgreSQL Performance Tuning Course - 3rd July 2017


10:00 AM
PostgreSQL Performance Tuning by Gianni Ciolli & Tomas Vondra

PostgreSQL Security Course - 3rd July 2017


10:00 AM
PostgreSQL Security Course - 3rd July 2017