PGConf Silicon Valley 2015
2015-11-17..2015-11-18
South San Francisco, United States
[PGConf Silicon Valley 2015, PGConf Silicon Valley 2016]
who it's for
Postgres DBAs, database architects, backend engineers, data engineers, site reliability engineers, operations engineers
topics
CitusDB sharding extension; Kafka commit log integration; Postgres logical change capture; INSERT ... ON CONFLICT (UPSERT); BRIN indexes for huge tables; materialized views with HyperLogLog; pg_shard logical shards; Prestogres Presto gateway; vc-pgsql-sniffer TCP reassembly; multi-plan race concurrent plans
| title | author | length |
|---|---|---|
| Breakout Session | Dan Robinson | 55m |
Claims that PostgreSQL + CitusDB power interactive analysis over ~50 terabytes of event data and tens of billions of rows (transcript cites ~80B events)… | ||
| Keynote – Ivan Novick | Ivan Novick | 14m |
PostgreSQL's permissive license seeds an ecosystem of vendor spin-offs rather than theory: PostgreSQL's permissive license enables multiple companies to build… | ||
| Keynote – Jay Kreps | Jay Kreps | 13m |
Explains a concrete system: Apache Kafka is a stand alone commit log that feeds databases, caches, and real time processors and scales across data centers. It… | ||
| Keynote – Umur Cubukcu | Umur Cubukcu | 16m |
Announces that CitusDB becomes a Postgres extension so you can create extension citusdb and get sharding, routing and parallel queries without forking… | ||
| Breakout Session | Scott Milliken | 59m |
MixRank moves from hundreds of GB to tens of terabytes by combining big machines and a cluster, tuning hardware and filesystems, using 70k IOPS and 3.7GB/s per… | ||
| Breakout Session | Baron Schwartz | 35m |
Captures Postgres traffic off the wire using VividCortex TCP sniffing libraries and a libpcap-based reassembly pipeline, emitting a MySQL slow‑query–style text… | ||
| Tutorial | Andres Freund, Marco Slot | 02h 00m |
Claims that PostgreSQL can replace multi-stage stacks by delivering real-time dashboards using materialized views, triggers and the HyperLogLog extension on… | ||
| Breakout Session | Matthew Kelly | 54m |
Postgres runs TripAdvisor’s core: over 100 dedicated servers across 4 datacenters, handling spikes beyond 1,500,000 database queries per minute, with… | ||
| Breakout Session | Magnus Hagander | 54m |
PostgreSQL 9.5 arrives with concrete changes: UPSERT (INSERT ON CONFLICT) provides atomic insert-or-update with an excluded virtual row, 2,700 files modified… | ||
| Breakout Session | Peter V Geoghegan | 53m |
PostgreSQL 9.5 adds a concrete UPSERT: an INSERT ... ON CONFLICT clause that either inserts or updates without racey subtransaction hacks and with better… | ||
| Breakout Session | Sadayuki Furuhashi | 40m |
Prestogres implements the PostgreSQL protocol so BI tools speak Postgres while queries run on Presto, rewriting SQL inside pgpool-II + PL/Python and creating… | ||
| Breakout Session | Jason Petersen | 53m |
Claims an open‑source PostgreSQL extension pg_shard that manages placement distribution and replication of shards and plugs into the regular Postgres… | ||
| Breakout Session | Grant McAlister | 54m |
Amazon RDS for PostgreSQL now doubles storage to 6 TB and uses gp2 which provides 3 IOPS per GB, letting larger volumes raise baseline IOPS; encryption at rest… | ||
| Tutorial | Josh Berkus | 02h 30m |
Hands‑on setup uses Vagrant/Docker VMs, tmux and psql to show real admin tasks: pg_dump/pg_restore for logical backups (fine for <1GB, restores can take hours… | ||
| Tutorial | Daniel Caldwell | 02h 18m |
Promise: a hands‑on PostGIS setup that actually imports shapefiles, fixes bad geometries, runs spatial queries and serves map tiles. Installs a Vagrant… | ||
| Breakout Session | Samantha Billington | 39m |
Detailed postmortems of streaming replication lag with concrete fixes and measurable failures: monitoring both time lag and byte lag, using… | ||
| Breakout Session | Álvaro Hernández | 54m |
ToroDB runs on top of PostgreSQL and claims a MongoDB-compatible API while storing data relationally rather than in jsonb, splitting documents into per-level… | ||
| Breakout Session | Christophe Pettus | 47m |
PCI DSS v3.1 (April 2015) demands concrete controls: require TLS 1.2, ban trust authentication and open 5432, use AES per-column encryption with solid key… | ||
| Breakout Session | Joe Conway | 49m |
Concrete methods and numbers: uses PostgreSQL extensions like pg_trgm and fuzzy_string_match, builds GIN/GiST and expression indexes, and tests on a messages… | ||
| Breakout Session | Paul Ramsey | 45m |
PostGIS surprises are concrete: mismatched SRIDs (e.g. data labelled 4326 but actually 3005) require ST_SetSRID or ST_Transform to fix coordinates, Mercator… | ||
| Tutorial | Bruce Momjian | 02h 44m |
Three-hour tutorial unpacks exactly what happens between sending SQL and getting rows: use of libpq PQexec over port 5432, tokenizing to a parse tree, and… | ||
| Breakout Session | Bruce Momjian | 56m |
Postgres positions itself as a central data broker by shipping concrete features: JSONB 9.4 with benchmarks showing much smaller indexes and dramatically… | ||
| Breakout Session | Gavin McQuillan | 28m |
Claims a working replacement for Hbase OLAP by combining PLProxy and Postgres-HLL: a distributed Postgres cluster that uses HLL sketches for commutative… | ||
| Breakout Session | Derek Nelson | 41m |
PipelineDB is an open-source streaming SQL database built as a fork of PostgreSQL 9.4.4 that runs continuous SQL queries called continuous views which… | ||
| Tutorial | Denish Patel | 02h 26m |
Claims that PostgreSQL 9.4 removes the need for external replication tooling by combining pg_basebackup and streaming with replication slots, a simple… | ||
| Breakout Session | Konstantin Gredeskoul | 56m |
Concrete claims and concrete fixes: the team scales a site to support millions of active users, handles 3B saves stored in PostgreSQL and achieves 99.999%… | ||
| Breakout Session | Ryan Lowe, John Cesario | 44m |
Compares concrete migrations: psql client with tab completion and backslash commands (\l, \dt, \d) replaces MySQL SHOW; role‑based accounts replace MySQL users… | ||
| Breakout Session | Kenny Gorman | 39m |
Shows concrete recipes using Ansible to manage PostgreSQL at scale with working code and real deployments at Rackspace and objectrocket, not vague promises… | ||
| Breakout Session | David Pacheco | 54m |
Automates PostgreSQL failover via an orchestrated cluster state in Manatee using ZooKeeper for consensus, a separate client layer Moire, ZFS for efficient… | ||
| Breakout Session | Greg Beruk | 47m |
Heroku Postgres runs about a million databases on AWS and uses LXC containers to keep runtime images uniform while storing data separately, grows disks via EBS… | ||
| Breakout Session | Andreas Scherbaum | 53m |
Geocoding and reverse geocoding run inside PostgreSQL by calling web services and caching results; modules for OpenStreetMap (nominatim) and Esri ArcGIS (Ares)… | ||
| Breakout Session | AJ Welch | 35m |
Claims that Postgres matches non‑relational analytics without sacrificing ACID, and demonstrates it by installing and composing real extensions: MADlib… | ||
| nothing matches | ||