Schedule for PGDay UK 2017
PGDay UK - 4th July 2017
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.
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
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
"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."
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.
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.
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.
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)!
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.