2Q PGConf

Date
December 4 & 5
Location
W Chicago - 172 West Adams Street, Chicago, Illinois 60603-3604

Welcome to 2Q PGConf 2019

2Q PGConf is a conference dedicated to exchanging knowledge about the world’s most advanced open source database: PostgreSQL

PostgreSQL is a powerful, open source object-relational database system with a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems and is well-equipped for enterprise use.

The current and future needs to store, access, and manage data can be challenging as the world of technology is constantly evolving and progressing. 2Q PGConf provides a unique opportunity to exchange ideas and learn more about PostgreSQL from world-class experts talking about both recent achievements and the exciting developments coming in the future.

In addition to the world class talks being presented in Chicago – we are also offering training sessions the day before the conference on December 4th.

About 2ndQuadrant

2ndQuadrant provides PostgreSQL Solutions for the Enterprise – reliably deploying them on the platform of your choice and providing 24/7 Production Support. Our solutions address all aspects of your database ecosystem, ensuring high availability, disaster recovery, backup & failover management, and much more.

Moreover, we provide tools to make your deployment process simple and reliable. With over 100 years of combined code contributions to the PostgreSQL project, our engineers ensure that your PostgreSQL solutions are fully supported in your production environment.

Schedule

Training - Wednesday, December 4th

8:30 - 5:30

PostgreSQL Security

This training course highlights the importance of database security within an enterprise. (more…)
TBD / 2ndQuadrant  
8:30 - 5:30

PostgreSQL Business Continuity

In this workshop we describe those PostgreSQL features that are most useful when implementing High Availability as well as Disaster Recovery. There are several third party solutions that might be
TBD / 2ndQuadrant  
8:30 - 5:30

The Ultimate Postgres Optimization: Going beyond docs and textbooks

Is it possible to teach somebody to optimize? Or is optimization a sort of magic, available only for the limited circle of wizards? We believe that it is entirely
Hettie Dombrovskaya and Boris Novikov / Braviant Holdings (Hettie Dombrovskaya) & High School for Economics, Russia (Boris Novikov)  
8:30 - 5:30

Postgres-BDR

This course covers the basic concepts of Bi-Directional Replication for PostgreSQL. (more…)
TBD / 2ndQuadrant  

Conference - Thursday, December 5th

09:20 - 10:00

A Case Study in “What If” PostgreSQL-BDR High-Availability/Disaster Recovery Analysis

This talk describes the evolving “what if” analysis of the PostreSQL-BDR “Always On” architecture for downtime, data loss, and system performance scenarios for a particular Billpay Solution at ACI Worldwide. In addition to accounting for five 9’s Availability for both planned and unplanned outages, the solution required analysing all
Dominic Mortimer / Principal Software Engineer, ACI Worldwide  
10:00 - 10:40

Recovering from Split Brain with Pg_waldump and Pg_rewind

Suppose you run PostgreSQL in a high-availability environment. What happens when you failover to your replica but STONITH fails and writes continue to occur on the old primary? Suffering from a split-brain with diverging timelines is a terrifying event for any engineer in this scenario. But we can use core
James Coleman / Software Engineer, Braintree Payments  
11:00 - 11:40

ORM Anti-Patterns

Database Administrators must often manage systems where the developers are coding with Object Relation Manager toolkits such as Django, Rails, Cake, etc. While these tools are helpful at the early stages of development, they also create problems that the developers cannot, or will not, solve. And then it is
Corey Huinker / President, Corlogic Consulting  
11:40 - 12:20

Conflict Handling in BDR Replication: What mechanisms are available, when should each be used and how to implement them correctly

At ACI Worldwide, we have a wide variety of payment related products leveraging PostgreSQL-BDR in Active-Active configurations. In these types of configurations, there are varying potentials for BDR related conflicts to occur. This presentation -- intended for an audience or Architects, Database Developers and/or DBA's -- will focus on
Keith Miller / Principal Architect , ACI Worldwide  
12:20 - 1:00

Bitemporality in PostgreSQL: What’s New

We have been developing pg_bitemporal library for over five years. It started as a proof of concept. We didn’t pay much attention to how performant were the bitemporal operations. Things changed three years ago, when we started to build the OLTP system at Braviant Holdings using the Asserted Versioning
Chad Slaughter & Hettie Dombrovskaya / Co-Founder, Scale Genius, inc & Associate Director of DB, Braviant Holdings  
2:00 - 2:40

The next generation Postgres High Availability

Postgres high availability has been stagnated for many years. This talk will discuss the existing high availability models for Postgres the advantages and current limitations. This talk will also present how the latest changes in computing with technologies like Kubernetes, HA proxy and Postgres-BDR and others can close the
Simon Riggs / Founder and CTO, 2ndQuadrant  
2:40 - 3:20

Building the Bridges: Why Research Community and Postgres Community Need Each Other

Although the origins of Postgres are in the academic world, communication and exchange of ideas between database research community and PostgreSQL community are negligibly small. In this talk I describe some of recent research advances that are or can be beneficial for PostgreSQL. Specifically, query optimization and concurrency control
Boris Novikov / National Research University Higher School of Economics  
3:20 - 4:00

12 in 12 — A closer look at twelve or so new things in Postgres 12

A closer look at twelve or so new things in Postgres 12. • Pluggable table storage (""AMs"") • Collations, case- & accent-insensitive queries • Indexes — smaller, faster, concurrent • Page checksums, enabled & disabled • JIT enabled by default • Common table expressions, inlined • OIDs: no system column oid • Statistics for query planner, improved
Basil Bourque / Developer  
4:20 - 5:00

Your account balance is eventually consistent – a Postgres Active-Active story from Banking

High Availability is critical for payment systems, as the cost of downtime for mission-critical systems in Banking is on average $10M per hour. System availability needs are expressed as “5 9’s”. This in practice requires both single-site and dual-site redundancy of database nodes, multi-master Active-Active processing across Data Centers,
Adrian Dozsa / Principal Software Engineer, ACI Worldwide  
5:00 - 5:40

DBA Automation at Enova with 500 Postgres Clusters

The DBA team at Enova manages 500 Postgres clusters, including masters, standbys, logical replicas, staging and snapshot clusters. We have powerful automation and configuration management tools that make it possible to configure, provision, upgrade, and monitor Postgres with ease. We will show you what it can do, how we
Jerry Sievers and Jeremy Finzel / Principal Engineer - Database Systems (Jerry), DBA Tech Lead (Jeremy); Enova International, Inc.  

2q PGConf SPONSORS 

GOLD

edb_logo_full_color
View the Prospectus
Become a Sponsor!

Call for Papers 

We will be hosting speakers giving dynamic presentations, case studies, and talks on the following topics:

  • New Features in PostgreSQL 12
  • PostgreSQL 13 – What’s in store for the future of PostgreSQL?
  • Deployment and Administration of large scale PostgreSQL installations
  • Case studies and/or success stories of PostgreSQL deployments (or interesting failures)
  • PostgreSQL tools and utilities
  • Community and local user groups
  • Tuning and performance improvements
  • Migration from other database systems
  • Replication, Clustering and/or High Availability
  • Disaster Recovery and Backup strategies
  • Benchmarking and hardware
  • DevOps and continuous deployment/configuration/integration around PostgreSQL

Call for Papers is now closed – keep an eye out for the 2019 schedule!

We would like to give a big thanks to our Talk Selection Committee!

Simon Riggs – Founder and CTO, 2ndQuadrant

Dave Pirotte – Developer, Braintree Payment Solutions

Henrietta Dombrovskaya – Braviant Holdings

Steve Emmerich – ACI Worldwide

Registration

2Q PGConf Location

W Chicago - City Center

172 West Adams Street,
Chicago, Illinois 60603-3604
+1 312-332-1200

© 2019 2ndQuadrant Ltd


Any profits from the 2ndQuadrant PostgreSQL Conference will be used to sponsor development work for future releases of Open Source PostgreSQL.