PGCon2017 - 20180510

PGCon 2017
The PostgreSQL Conference

Schedule Talks - Day 2

DMS 1160 DMS 1110 DMS 1120 DMS Lobby
DMS 1160 DMS 1110 DMS 1120 DMS Lobby
09:30

Coffee & light snacks

in the lobby

09:45
10:00

Multi-objective Query Optimization in PostgreSQL

Tradeoff between execution-time and resource-requirements!

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

Automatic Failover and new nodes provisioning made easy.

PostgreSQL Entangled in Locks: Attempts to free it

10:15
10:30
10:45
11:00

PostgreSQL Security

How Do We Think?

So You Want To Make An Extension?

Oh, that ubiquitous JSON !

Present and future of Jsonb in PostgreSQL

11:15
11:30
11:45

Lunch

nom nom nom

12:00
12:15
12:30
12:45
13:00

Towards Built-in Sharding in Community PostgreSQL

Jaywalking in Traffic: Safe Migrations at Scale

Provisioning and Automating High Availability Postgres on AWS EC2

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

13:15
13:30
13:45

Coffee & light snacks

in the lobby

14:00

Troubleshooting PostgreSQL with pgCenter

Finding and eliminating performance issues with pgCenter

OUZO for indexing sets

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

Towards Comprehensive Testing Tools

Redefining testing mechanisms!

14:15
14:30
14:45
15:00

UNDERSTANDING POSTGRESQL QUERY PLANS (AKA EXPLAIN)

JIT-Compiling SQL Queries in PostgreSQL Using LLVM

SCRAM authentication in PostgreSQL

15:15
15:30
15:45
16:00

PostgreSQL Monitoring Enhancements

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

Pgcrypto avast!

A study in Django's password hashers

Partition and conquer large data with PostgreSQL 10

Declarative partitioning comes to PostgreSQL

16:15
16:30
16:45
17:00
17:15

Closing sessions

prizes, auctions, fun, games

17:30
17:45
18:00