PGCon2014 - Final Release

PGCon 2014
The PostgreSQL Conference

Event Speakers

"A Tale of Two Oracle Migrations"

Deploying PostgreSQL at Japan's second-largest stock exchange

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

9.4 On The Floor

How 9.4 will shake your world

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

An Adventure in Data Modeling

The Entity-Attribute-Value Model

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

Bacula

Everything you need to know about backups

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

Balancing Database Storage Latency And Throughput

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

CREATE INDEX ... USING VODKA

An efficient indexing of nested structures

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

Closing sessions

prizes, auctions, fun, games

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

Clustering and Replication

Developers Summit

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

Cyan Audit

Forensic DML Logging for PostgreSQL

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

Explaining the Postgres Query Optimizer

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

FreeBSD Jails

Virtualization, isolation, great backup/restore

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

GIN - Stronger than ever

in 9.4 and further

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

Gaia

Mapping a billion stars throughout our Galaxy and beyond

Event type : Lecture
Track : Big Data
Language used for presentation : English

HSTORE, XML, JSON, JSONB OH MY!

Use the unstructured data type that's right for you.

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

Hacker Lounge

meet, greet, code, slack

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

Hacker Lounge

meet, greet, code, slack

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

HowTo DR

planning for the worst

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

I know greater-than-or-equal-to when I see it!

A tour of the operator class facility

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

Implementing Parallelism in PostgreSQL

Where We Are Today, and What's On The Horizon

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

In-Memory Columnar Store extension for PostgreSQL

Event type : Lecture
Track : Big Data
Language used for presentation : English

Json - what's new in 9.4, and what's left to do.

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

Lightning talks

Short sharp descriptions of short topics

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

Major Social Event!

sponsored by EnterpriseDB

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

Mission Impossible

Scaling a 100% Cloud Native Analytics Engine

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

Mobile Canvassing and PostgreSQL

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

Multicorn: writing FDWs in Python

A tutorial showing off Multicorn's features

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

PgREST

PostgreSQL, JavaScript, and REST

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

PostgreSQL (System) Administration

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

PostgreSQL Replication Security

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

PostgreSQL experience in Russian Parliament

Success story of PostgreSQL in Russian State Duma

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

PostgreSQL, Range Types, and Rust

Combining database features with language features

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

Postgres in Amazon RDS

A compelling option for startups

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

Postgres on the wire

A look at the PostgreSQL wire protocol

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

PostgresXC Developer

meeting

Event type : Meeting
Track : Hacking
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

SELECT * FROM changes; -- Changeset Extraction

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

SQLite: Protégé of PostgreSQL

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

Static analysis, test coverage, and other 12+ letter words

A tour of ways to find and prevent bugs in PostgreSQL

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

The Art of Indexing

How to get most out of B-tree indexes

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

The Next Five Years for PostgreSQL Advocacy

or "How We Can Overtake Every Other Database"

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

The Worst Day of Your Life

Recovering from Crises and Disasters

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

Unconference

Room #1

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

Unconference

Room #1

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

Unconference

Room #1 afternoon

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

Unconference

Room #2

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

Unconference

Room #2

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

Unconference

Room #2

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

Unconference

Room #2

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

Using PostgreSQL as a benchmarking tool

How we used PGbench to improve performance of the DragonFly operating system

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

Using PostgreSQL with Java

The elephant and Duke playing together

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

What Do You Mean my Database Server Core Dumped?

How to Inspect Postgres Core Dumps

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

When PostgreSQL Can't, You Can

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

Why UPSERT is weird

Counterintuitive lessons learned from the implementation effort

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

Working with PostgreSQL network data types: A hands-on workshop

Working examples of how to validate, load, store and operate on IPv4/6 and MAC address data

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

Writing portable postgreSQL-backed applications for the Open Cloud

Instant Mapping Applications with PostGIS and Nodejs

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