Postgres Open 2012
2012-09-17..2012-09-19
Chicago, United States
| title | author | length |
|---|---|---|
| Keynote | Jacob Kaplan-Moss | 56m |
Claims that Django defaults to Postgres because everything just works and argues for a single “post‑SQL” database that combines ACID relational features with… | ||
| Range Types in PostgreSQL 9.2 - Your Life Will Never Be the Same | Jonathan S. Katz | 50m |
PostgreSQL 9.2 adds concrete range types (ints, numerics, timestamps, dates) with operators like && (overlaps), functions lower/upper, and GiST indexing so… | ||
| Scaling out by distributing and replicating data in Postgres XC | Ashutosh Bapat | 54m |
Postgres-XC is a shared‑nothing PostgreSQL cluster with coordinators, datanodes and a GTM; the team builds a cluster, adapts table creation and runs DBT‑V… | ||
| PostgreSQL When It's Not Your Job | Christophe Pettus | 57m |
Use packages to install PostgreSQL and set shared_buffers to 25% of RAM capped at 8GB, set max_connections ~200, maintenance_work_mem = RAM/16, and tune… | ||
| Large Scale MySQL Migration to PostgreSQL | Dimitri Fontaine | 59m |
A Top-10 photo site moves its data and code off MySQL to PostgreSQL under a fixed deadline: 32 million users 1 billion photos >6TB get exported and reshuffled… | ||
| Choosing a logical replication system: Slony vs Bucardo | David Christensen | 47m |
Slony implements a serialized, trigger-driven event log and enforces replica immutability with deny-write triggers on replicas, plus useful features like… | ||
| Temporal Database Demo | Jeff Davis | 01h 03m |
Builds a working temporal schema for assets, rooms and people and shows queries that actually run: PostgreSQL 9.2 range types store time spans, exclusion… | ||
| 12 Calm Years of PostgreSQL in Critical Messaging | John Scott | 55m |
PostgreSQL runs production critical messaging since 2000 for hospitals, EMS and fire, replacing a commercial RDBMS and later Sleepycat for routing; it handles… | ||
| PostgreSQL in the cloud: Theory and Practice | John Melesky | 43m |
Claims that decades of tuning break in the cloud lead to concrete checks: run Bonnie++ on EC2, expect huge variability; network‑attached disks and shared pipes… | ||
| PostgreSQL Backup Strategies | Magnus Hagander | 56m |
Replication does not replace backups: a real outage once nukes 5,000 VMs and takes months to recover. Concrete options: pg_dump (custom format) for logical… | ||
| This Is PostGIS | Paul Ramsey | 53m |
PostGIS. A spatial database extension for PostgreSQL. What spatial data is, the questions you can answer with it, the features of PostGIS explained, with an… | ||
| Embracing the Web with JSON and PLV8 | Will Leinweber | 43m |
Uses Postgres 9.2 JSON plus the PLV8 JavaScript PL to treat rows as documents, build functions (mustache, jsonselect) and create expression indexes that are… | ||
| How Akiban Implemented a New Database Compatible with the PostgreSQL Protocol | Ori Herrnstadt | 55m |
Akiban Server is built from scratch and exposes SQL plus a REST API and chooses the PostgreSQL wire protocol so existing drivers work. Implementation is a Java… | ||
| High Availability with PostgreSQL and Pacemaker | Shaun M. Thomas | 55m |
Claims a way to lose no committed transactions by moving replication below PostgreSQL using DRBD block-level synchronous writes and keeping Postgres on an… | ||
| Logging Not Just for Lumberjacks | Gabrielle Roth | 43m |
PostgreSQL logging turns on with one config change and rotates by default daily or at 10MB, so expect many files unless rotation/cleanup is scripted. Choose… | ||
| Full-text search - seek and ye shall find | Dan Scott | 59m |
Demonstrates PostgreSQL full‑text search working on a million Open Library rows and 40 years of student newspapers ingested from archive.org, using TSVector… | ||
| Scaling Postgres With Some Help from Redis | Josiah Carlson | 50m |
Combining Postgres for durable storage with Redis for high‑throughput in‑memory work proves concrete: Redis benchmarks at ~300k pipelined ops/sec on one core… | ||
| Leveraging PLV8 in Javascript heavy Web Applications | Taras Mitran | 20m |
Demonstrates running browser JavaScript inside Postgres via PLV8 runs Google V8 in the database to reuse client code for server-side persistence and… | ||
| An Object Oriented Approach to Data Driven Software Development | David Benoit | 41m |
Claims a concrete, battle-tested system that replaces inline SQL with stored procedures at Starscale to get encapsulation, fewer round trips and measurable… | ||
| A Shared nothing Cluster System Postgres XC | Amit Khandekar | 56m |
Postgres-XC aims for write-scalability with a shared-nothing architecture using coordinators, data nodes and a GTM that hands out global transaction IDs and… | ||
| A Batch of Commit Batching | Peter V Geoghegan | 47m |
PostgreSQL 9.2 introduces a lock and fast‑path change that makes PostgreSQL 9.2 group commit batch hundreds of logical commits into one fsync, yielding… | ||
| TransLattice Elastic Database Architecture Deep Dive | Christine Normile | 59m |
Claims a production geographically distributed RDBMS built on PostgreSQL and Postgres-R, shipping standalone Q2 2012 after work since 2007. Architecture uses a… | ||
| Retail DDL | Andrew Dunstan | 41m |
Retail DDL is an extension of about thirty server-side functions that generate CREATE/ALTER SQL for individual objects so you avoid pg_dump’s overhead and… | ||
| Programming the SQL Way with Common Table Expressions | Bruce Momjian | 57m |
Shows exactly what Common Table Expressions do and how far they go: demos of with recursive loops that print 1–10, compute factorial and prime factors, tree… | ||
| PG Extractor - A smarter pg dump | Keith Fiske | 25m |
A Perl tool called pg_extractor uses pg_dump and pg_restore to emit database schema as per-object files (tables views functions types roles) and to capture… | ||
| DVDStore Benchmark and PostgreSQL | Jignesh Shah | 54m |
Benchmarks show DVDStore ports for PostgreSQL with Tomcat/JDBC, Web Server/PHP and Postgres Stored Procedure services and include CentOS, Tomcat/Apache, PHP… | ||
| Super Jumbo Delux | Josh Berkus | 58m |
Argues that PostgreSQL is the go-to first tool for data warehousing before proprietary systems or MapReduce and shows concrete limits and wins: index-only… | ||
| Query Logging and Workload Analysis | Greg Smith | 57m |
Argues that collecting slow queries is not enough and that PostgreSQL 9.2’s pg_stat_statements and related tooling make real workload analysis practical… | ||
| Postgres is the new default | Inés Sombra | 31m |
Engine Yard makes Postgres the default database, migrating from MySQL 5.x to Postgres 9.0/9.1 by overhauling provisioning with Chef cookbooks, EBS snapshots to… | ||
| Deploying Maximum HA Architecture With Postgres | Denish Patel | 46m |
Claims that Postgres 9.x supports 99.99% availability translate into a concrete architecture: a floating VIP, hybrid streaming replication + WAL shipping for… | ||
| Performance Improvements in PostgreSQL9 2 | Robert Haas | 56m |
PostgreSQL 9.2 delivers concrete wins: a fast-path lock manager and cache-splitting reduce cache-line thrash and scale nearly linearly to 64 cores on test… | ||
| nothing matches | ||