PostgresOpen 2014
who it's for
Postgres DBAs, Postgres developers, site reliability engineers, devops engineers, application developers, data engineers, security engineers
topics
query optimizer scans and joins; logical decoding and replication; libpq one-row interface performance; pgbench automated benchmarking; jsonb GIN indexes; Postgres-XL for OLTP and analytics; row level security; pgBackRest backup tooling; PostGIS KNN GiST indexes; columnar store extension for Postgres; partitioning quantitative analysis; migrating MySQL full text search
| title | author | length |
|---|---|---|
| Explaining the Postgres Query Optimizer | Bruce Momjian | 51m |
Explains what the Postgress optimizer actually decides: whether to use a sequential scan, bitmap scan or index scan, which join algorithm (nested‑loop, hash… | ||
| Scalability, Consistency, Replication, Availability and Performance | Simon Riggs | 53m |
Claims that logical decoding lands in 9.4 and a BDR prototype supports 48 nodes tested with near-physical-replication throughput (about a 5–10% throughput drop… | ||
| Who's the Fairest of Them All? Postgres Interface Performance | Joe Conway | 48m |
Automated C and Java clients plus a tiny Postgres extension measure durations for 268 test cases run three times across libpq (normal, one-row interface, copy… | ||
| Automated Performance Testing of Postgres | Greg Burek | 36m |
Heroku builds an automated pipeline that compiles Postgres, injects benchmarking tools and runs pgbench collector and pgbench workloads on isolated px dynos… | ||
| On Beyond Data Types | Jonathan S. Katz | 53m |
Postgres proves the claims with numbers: creating an expression index on plot area turns a sequential scan into an index scan and speeds queries about 15×; a… | ||
| PostgreSQL Scale-Out at inMobi | Sivakumar | 50m |
Postgres runs the ad stack at scale: 8 billion ads a day and ~240 TB ingested daily, growing from one Postgres 8.3 node to 100+ instances across six data… | ||
| PostgreSQL for Developers | Dimitri Fontaine | 44m |
Argument that SQL is a real programming language, demonstrated by concrete solutions: a nine‑line query using window functions and CTEs that computes monthly… | ||
| PostgreSQL and Java: Best Practices | Álvaro Hernández | 52m |
Shows concrete outcomes and code: a GitHub repo with runnable examples, a psql-via-stdin trick that achieves 12,000 tables per second, comparison of drivers… | ||
| Row Level Security | Stephen Frost | 53m |
Postgres adds native row‑level security in 9.5: enable it per table with ALTER TABLE ENABLE ROW LEVEL SECURITY, define per‑command policies with CREATE POLICY… | ||
| Understanding Logical Decoding and Replication | Michael Paquier | 54m |
Explains that PostgreSQL 9.4 adds logical replication slots and a plugin API that reads WAL, decodes changes, and exposes them over the replication protocol or… | ||
| Sponsor Keynote #2 | Simon Riggs | 19m |
Uses the Epimenides joke to point at concrete problems—data completeness, column semantics, concurrency locking, privacy and who can update values—and argues… | ||
| Postgres in Amazon RDS | Denish Patel | 53m |
Amazon RDS runs Postgres Postgres 9.3 as a managed, production-ready service with automatic backups, SSL on by default, and built-in monitoring, but it forbids… | ||
| The NoSQL Way in PostgreSQL | Vibhor Kumar | 48m |
PostgreSQL claims it handles NoSQL workloads by adding hstore, JSON (9.2/9.3) and JSONB with GIN index (9.4) while keeping ACID. A benchmark harness run on… | ||
| What's New in PostgreSQL 9.4 | Magnus Hagander | 48m |
PostgreSQL 9.4 adds concrete, usable features: jsonb stores parsed JSON but does not preserve key order and supports GIN/GIN‑trgm indexing for fast containment… | ||
| Survival Analysis of Customer Retention using Postgres, SQL and R | Gleb Arshinov | 52m |
Shows a working pipeline that computes the Kaplan-Meier estimator from event rows using Postgres SQL and R via the plr extension, handles censored observations… | ||
| Supersized Postgres: Postgres-XL for OLTP and Big Data Analytics | Mason Sharp | 50m |
Postgres-XL claims a single scale-out Postgres that handles OLTP and MPP analytics, implements cluster-wide MVCC by handing out global transaction IDs via a… | ||
| Row-Estimation Revelation and the Monolithic Query Syndrome | Jeff Amiel | 41m |
Claim: planner row counts are often wildly wrong causing wrong join choices and catastrophic slowdowns — row estimates off by orders of magnitude. Evidence… | ||
| PoastgreSQL Auditing, Authentication, and Security | Sehrope Sarkuni | 40m |
Describes a deployed system (JackDB) that centralizes authentication, rotates database credentials server‑side, and records immutable query logs across… | ||
| Heavy Duty Backup w/PgBackRest | David Steele | 51m |
pgBackRest targets very large Postgres installs and delivers parallel backups, efficient incrementals that can resume after failure, and asynchronous archive… | ||
| Collectd and Graphite: Monitoring PostgreSQL w/Style | Shaun Thomas | 51m |
Shows a working collectd + Graphite stack for PostgreSQL monitoring with concrete configs not vague promises it uses the collectd postgres plugin to run… | ||
| Holistic Database Application Tuning | Grant Evans, Henrietta Dombrovskaya | 42m |
Database changes reduce hundreds of per-page queries to one by turning Ruby methods into a single data‑set method backed by Postgres; logs from PG Badger show… | ||
| How Databases Work - For Developers, Accidental DBA's and Managers | Gurjeet Singh | 49m |
Postgres internals explained as concrete mechanics not marketing: data lives in 8KB blocks with row pointers, parsing → planner → executor produces plans like… | ||
| So you're new to Postgres... | Michael Alan Brewer | 52m |
Quick newcomer roadmap: Postgres guarantees ACID and MVCC for data integrity, releases a new major version roughly every year (four active release lines right… | ||
| Postgres on OpenStack | Dave Page | 51m |
Claims concrete deployable steps: use Glance image + snapshot workflow to ship clean Postgres images, create Nova flavors + host-aggregate extra_specs to pin… | ||
| The Three Musketeers (Authentication, Authorization, and Accounting) | Sarah Conway | 35m |
Applies the AAA model to Postgres with concrete knobs: use pg_settings to see which parameters need reload vs restart, edit postgresql.conf for SSL and set… | ||
| Use PostgreSQL, not Rails, to make Rails Faster! | Dan McClain | 46m |
Claims that shifting work into PostgreSQL — using arrays, GIN index, hstore/jsonb, window functions and CTEs — removes ActiveRecord churn and cuts latency… | ||
| Tales from the Postgres Front, and What We Can Learn | Marc Linster | 36m |
Migrations come mostly from Oracle and sequel server with a post‑2014 jump tied to Microsoft pricing and Hibernate often making migrations trivial, but the… | ||
| Immutable Data in Postgres | Gary Sieling | 46m |
Builds immutable audit by writing shadow tables with $ suffix and lightweight triggers that copy inserts updates deletes, records the Postgres transaction id… | ||
| Migrating Away from MySQL for an awesome full text search | Peter Bengstsson | 43m |
Migrates a Django app from MySQL to Postgres using Pi MySQL to pgsql (simple YAML script) and later PG loader (bulk load then create indexes) and measures real… | ||
| Columnar Store for PostgreSQL | Ben Redman | 46m |
c-store fdw is an open-source columnar foreign-data-wrapper for PostgreSQL that writes column stripes using the ORC format, installs as an extension, and… | ||
| Frictionless Data Science w/Python | Catherine Devlin | 46m |
IPython Notebook wins groundwork credibility (2012 Free Software Award) and runs live cells plus a %sql magic via ipython-sql to pipe results into… | ||
| A Quantitive Look at Partitions | John Melesky | 51m |
Benchmarks use EC2 and RDS to measure insert and read cost for monolithic tables, partial indexes, and various partitioning strategies with 50,000 partitions… | ||
| nothing matches | ||