PGCon2016 - 20180510

PGCon 2016
The PostgreSQL Conference

Event Speakers

9.4 The Hard Way

Version upgrades with pg_upgrade and rsync using hard links

Event type : Lecture
Track : DBA
Language used for presentation : English

A Challenge of Huge Billing System Migration

Event type : Lecture
Track : Case Studies
Language used for presentation : English

Audit Logging for PostgreSQL

Event type : Lecture
Track : DBA
Language used for presentation : English

Autovacuum, explained for engineers

Event type : Lecture
Track : DBA
Language used for presentation : English

B-Tree - explore the heart of PostgreSQL.

Event type : Lecture
Track : Hacking
Language used for presentation : English

Benchmarking Databases

Performance Evaluation

Event type : Lecture
Track : Performance
Language used for presentation : English

Beyond EXPLAIN: Query Optimization From Theory To Code

Event type : Lecture
Track : Hacking
Language used for presentation : English

Building a BaaS using PostgreSQL

From schema to REST API instantly

Event type : Lecture
Track : Applications
Language used for presentation : English

Closing sessions

prizes, auctions, fun, games

Event type : Other
Track : Social
Language used for presentation : English

Coffee & light snacks

Developer Conference - afternoon

Event type : Lecture
Track : Social
Language used for presentation : English

Coffee & light snacks

Developer Conference -afternoon

Event type : Lecture
Track : Social
Language used for presentation : English

Coffee & light snacks

Developer Unconference - morning

Event type : Lecture
Track : Social
Language used for presentation : English

Coffee & light snacks

From 8:30

Event type : Lecture
Track : Social
Language used for presentation : English

Coffee & light snacks

in the lobby

Event type : Lecture
Track : Social
Language used for presentation : English

Coffee & light snacks

in the lobby

Event type : Lecture
Track : Social
Language used for presentation : English

Coffee & light snacks

in the lobby

Event type : Lecture
Track : Social
Language used for presentation : English

Developer Unconference

Room #1

Event type : Lecture
Track : Developer Unconference
Language used for presentation : English

Developer Unconference

Room #1

Event type : Lecture
Track : Developer Unconference
Language used for presentation : English

Developer Unconference

Room #1

Event type : Lecture
Track : Developer Unconference
Language used for presentation : English

Developer Unconference

Room #1

Event type : Lecture
Track : Developer Unconference
Language used for presentation : English

Developer Unconference

Room #1

Event type : Lecture
Track : Developer Unconference
Language used for presentation : English

Developer Unconference

Room #2

Event type : Lecture
Track : Developer Unconference
Language used for presentation : English

Developer Unconference

Room #2

Event type : Lecture
Track : Developer Unconference
Language used for presentation : English

Developer Unconference

Room #2

Event type : Lecture
Track : Developer Unconference
Language used for presentation : English

Developer Unconference

Room #2

Event type : Lecture
Track : Developer Unconference
Language used for presentation : English

Developer Unconference

Room #3

Event type : Lecture
Track : Developer Unconference
Language used for presentation : English

Developer Unconference

Room #3

Event type : Lecture
Track : Developer Unconference
Language used for presentation : English

Developer Unconference

Room #3

Event type : Lecture
Track : Developer Unconference
Language used for presentation : English

Developer Unconference

Room #3

Event type : Lecture
Track : Developer Unconference
Language used for presentation : English

ERROR: snapshot too old

(why having the option of seeing that is a good thing)

Event type : Lecture
Track : 9.6 Features
Language used for presentation : English

Experience Cuba with PostgreSQL: PostgreSQL Diploma

Research and teaching with PostgreSQL

Event type : Lecture
Track : Case Studies
Language used for presentation : English

FTS is dead? Long live FTS!

New features of Full-text search in PostgreSQL

Event type : Lecture
Track : Hacking
Language used for presentation : English

Faster PostgreSQL: Improved Writes

Event type : Lecture
Track : Performance
Language used for presentation : English

Foreign Data Wrappers - how to write them and use them.

Foreign data wrappers made easy

Event type : Workshop
Track : Tutorial
Language used for presentation : English

Hands-On Lab: New PostgreSQL 9.5 features

No bullshit: BYOL and try it out!

Event type : Workshop
Track : Tutorial
Language used for presentation : English

How I Learned to Stop Worrying and Love Failover

Automated HA on a container stack

Event type : Lecture
Track : Scaling Out
Language used for presentation : English

In-memory column store

Event type : Lecture
Track : Hacking
Language used for presentation : English

Index Internals

Event type : Lecture
Track : Hacking
Language used for presentation : English

Lessons in Building a Distributed Query Planner

Why Some SQL Queries are Hard to Scale

Event type : Lecture
Track : Scaling Out
Language used for presentation : English

Lightning talks

Short sharp descriptions of short topics

Event type : Lightning-Talk
Track : Plenary
Language used for presentation : English

Lunch

Developer Conference

Event type : Lecture
Track : Social
Language used for presentation : English

Lunch

User Unconference

Event type : Lecture
Track : Social
Language used for presentation : English

Lunch

unconference lunch

Event type : Lecture
Track : Social
Language used for presentation : English

Lunch

unconference lunch

Event type : Lecture
Track : Social
Language used for presentation : English

MLS PostgreSQL

Implementing Multi-level Security in PostgreSQL with RLS and SELinux

Event type : Lecture
Track : Hacking
Language used for presentation : English

Managing OS Provided PostgreSQL Packages

Event type : Lecture
Track : DBA
Language used for presentation : English

Non-volatile Memory Logging

Event type : Lecture
Track : Performance
Language used for presentation : English

Not Easy Being Green

The Long Tail of Buildfarm Failures

Event type : Lecture
Track : Hacking
Language used for presentation : English

Opening Session & Keynote

PostgreSQL Extensibility

Event type : Lecture
Track : Plenary
Language used for presentation : English

Overlooked Data Types

A study of useful lesser-known data types.

Event type : Lecture
Track : Applications
Language used for presentation : English

Parallel Query Has Arrived!

Where We've Been, Where We Are, and Where We're Going

Event type : Lecture
Track : 9.6 Features
Language used for presentation : English

PoWA 3: towards a computer assisted DBA

Event type : Lecture
Track : DBA
Language used for presentation : English

PostgreSQL High-Availability and Geographic Locality using consul...

The website may be down, but the database is not.

Event type : Lecture
Track : Scaling Out
Language used for presentation : English

PostgreSQL When It is Not Your Job

Confidence in Your DevOps Role

Event type : Workshop
Track : Tutorial

PostgreSQL extendability: Origins and new horizons

Towards pluggable storage engines

Event type : Lecture
Track : Hacking
Language used for presentation : English

PostgreSQL's buffer manager - Problems & Improvements

Event type : Lecture
Track : Hacking
Language used for presentation : English

Postgres Rocks Party!

sponsored by EnterpriseDB

Event type : Other
Track : Social
Language used for presentation : English

Queues in PostgreSQL

Can elephants queue?

Event type : Lecture
Track : Applications
Language used for presentation : English

Registration Bag Assembly

TBA

Event type : Other
Track : Social
Language used for presentation : English

Registration pickup

The social way to register: at the pub

Event type : Other
Track : Social
Language used for presentation : English

Run Simple Query Faster

Event type : Lecture
Track : Performance
Language used for presentation : English

Session Pitches and Scheduling

Coffee and snacks

Event type : Lecture
Track : User Unconference
Language used for presentation : English

Setting up Vault for HA PKI and Secrets management...

Secure access to PostgreSQL, simplified

Event type : Workshop
Track : Tutorial
Language used for presentation : English

The PCI Compliant Database.

... yours probably is not.

Event type : Lecture
Track : Applications
Language used for presentation : English

Unveiling pg_global_kv

A distributed key value store built on top Postgres

Event type : Lecture
Track : Scaling Out
Language used for presentation : English

User Unconference

Room #1

Event type : Lecture
Track : User Unconference
Language used for presentation : English

User Unconference

Room #1

Event type : Lecture
Track : User Unconference
Language used for presentation : English

User Unconference

Room #1

Event type : Lecture
Track : User Unconference
Language used for presentation : English

User Unconference

Room #1

Event type : Lecture
Track : User Unconference
Language used for presentation : English

User Unconference

Room #2

Event type : Lecture
Track : User Unconference
Language used for presentation : English

User Unconference

Room #2

Event type : Lecture
Track : User Unconference
Language used for presentation : English

User Unconference

Room #2

Event type : Lecture
Track : User Unconference
Language used for presentation : English

User Unconference

Room #2

Event type : Lecture
Track : User Unconference
Language used for presentation : English

User Unconference

Room #3

Event type : Lecture
Track : User Unconference
Language used for presentation : English

User Unconference

Room #3

Event type : Lecture
Track : User Unconference
Language used for presentation : English

User Unconference

Room #3

Event type : Lecture
Track : User Unconference
Language used for presentation : English

User Unconference

Room #3

Event type : Lecture
Track : User Unconference
Language used for presentation : English

WAL Reduction

Lose WAL size, gain performance

Event type : Lecture
Track : Performance
Language used for presentation : English

Yandex.Mail success story

Experience of a big migration from Oracle to PostgreSQL

Event type : Lecture
Track : DBA
Language used for presentation : English

pg_paxos: Paxos-based table replication

Bringing the magic of distributed consensus to PostgreSQL

Event type : Lecture
Track : Scaling Out
Language used for presentation : English