PGCon2017 - 20180510

PGCon 2017
The PostgreSQL Conference

Event Speakers

Adaptive query optimization in PostgreSQL

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

Building PostgreSQL and extensions on and for Windows

the ways are many ...

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

Closing sessions

prizes, auctions, fun, games

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

Codified PostgreSQL Schema

Idempotent Schema Migrations for Developers and DBAs

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

Coffee & light snacks

From 8:30

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

Coffee & light snacks

Unconference -afternoon

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

Coffee & light snacks

in the lobby

Event type : Other
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 : Other
Track : Social
Language used for presentation : English

Corruption War Stories

Real-Life Corruption Issues and Recovery

Track : Case Studies
Language used for presentation : English

Designing your Multi-tenant Database for Scale with Postgres

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

Designing your Multi-tenant Database for Scale with Postgres

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

Don't stop the world

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

Efficiently Backing up Terabytes of Data with pgBackRest

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

Extending View Updatability by a Novel Theory

Prototype Implementation on PostgreSQL

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

Faster And Reliable Hash Indexes

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

Hash Joins: Past, Present and Future

A peek inside the engine room

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

Integrating Just In Time Compilation to make Postgres faster

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

JIT-Compiling SQL Queries in PostgreSQL Using LLVM

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

Jaywalking in Traffic: Safe Migrations at Scale

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

Lies, damned lies, and statistics

A journey into the PostgreSQL statistics subsystem

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

Lightning talks

Short sharp descriptions of short topics

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

Linux tuning to improve PostgreSQL performance: from hardware to postgresql.conf

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

Logical Replication in PostgreSQL 10

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

Lunch

Unconference

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

Lunch

nom nom nom

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

Lunch

nom nom nom

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

Multi-objective Query Optimization in PostgreSQL

Tradeoff between execution-time and resource-requirements!

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

OUZO for indexing sets

Accelerating queries to sets with GIN, GiST, and custom indexing extensions

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

Oh, that ubiquitous JSON !

Present and future of Jsonb in PostgreSQL

Event type : Lecture
Track : Hacking

Opening Session

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

Parallel Query v2

The herd of elephants we unleashed claims new territory

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

Partition and conquer large data with PostgreSQL 10

Declarative partitioning comes to PostgreSQL

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

Pgcrypto avast!

A study in Django's password hashers

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

PostgreSQL Entangled in Locks: Attempts to free it

Event type : Lecture
Track : Performance

PostgreSQL HA in the clouds with Docker, Spilo and Patroni.

Automatic Failover and new nodes provisioning made easy.

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

PostgreSQL Monitoring Enhancements

How long before a utility command finishes and what additions can be made to existing wait events?

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

PostgreSQL Security

How Do We Think?

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

PostgreSQL When It is Not Your Job

Confidence in Your DevOps Role

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

PostgreSQL backups the modern way

Event type : Lecture
Track : DBA

PostgreSQL performance

The other side

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

Provisioning and Automating High Availability Postgres on AWS EC2

Simple automation techniques to make Postgres cluster management easier at any scale.

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

Registration Bag Assembly

TBA

Event type : Other
Language used for presentation : English

Registration pickup

The social way to register: at the pub

Event type : Other
Language used for presentation : English

SCRAM authentication in PostgreSQL

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

Session Pitches and Scheduling

Coffee and snacks

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

So You Want To Make An Extension?

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

Towards Built-in Sharding in Community PostgreSQL

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

Towards Comprehensive Testing Tools

Redefining testing mechanisms!

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

Troubleshooting PostgreSQL with pgCenter

Finding and eliminating performance issues with pgCenter

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

UNDERSTANDING POSTGRESQL QUERY PLANS (AKA EXPLAIN)

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

Unconference

Room #1

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

Unconference

Room #1

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

Unconference

Room #1

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

Unconference

Room #1

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

Unconference

Room #2

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

Unconference

Room #2

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

Unconference

Room #2

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

Unconference

Room #2

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

Unconference

Room #3

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

Unconference

Room #3

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

Unconference

Room #3

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

Unconference

Room #3

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