PostgresOpen 2013
who it's for
postgres DBAs, postgres developers, devops engineers, site reliability engineers, database architects, cloud platform engineers, postgres extension developers
topics
postgres_fdw federated queries; custom background workers API; parallel pg_dump and restore; using JSON with Postgres 9.3; streaming plus WAL shipping replication; pgbouncer connection pooling; partitioning with pg_partman; Alembic schema migrations; Postgres-XC cluster management; page checksums storage protection; PostgreSQL on ZFS; HyperLogLog scalable uniques
| title | author | length |
|---|---|---|
| Keynote - Embracing Openness as a Competitive Advantage | Jesse Noller | 53m |
Argues that making products open source by default boosts adoption and resilience, citing Rackspace’s investment in OpenStack (an operating system for cloud)… | ||
| Scaling Postgres | Denish Patel | 58m |
Recommendations and concrete tooling for scaling Postgres: prefer lots of RAM (64 GB minimum, 128–512 GB or more) and RAID10 SSDs, tune shared_buffers and… | ||
| What's New in PostgresSQL 9.3 | Magnus Hagander | 55m |
PostgreSQL 9.3 ships (released Sept 9) with about 227,000 lines added and ~100,000 removed and delivers concrete changes: SQL-level lateral queries and richer… | ||
| Taking advantage of custom background workers | Michael Pequier | 01h 00m |
Custom background workers run continuous daemon code inside Postgres with direct access to databases, shared memory and transactions and they are powerful but… | ||
| Query Planning Gone Wrong | Robert Haas | 56m |
Surveying 168 reports from pgsql-performance yields concrete failure modes: 168 reports are classified into settings (23), inherently slow requests (23)… | ||
| Recovering from a damaged cluster | Robert Bernier | 45m |
A real case recovers a 2 tera-byte database corrupted by bad RAM by booting Postgres with zero_damage_pages to ignore damaged blocks, using single-user mode to… | ||
| Middleware is Dead! | David Benoit | 42m |
Claim: an HTTP server runs inside PostgreSQL so clients call stored procedures by POSTing JSON directly. Prototype embeds microhttpd as an extension and is… | ||
| Sane schema migrations with Alembic and Postgres | Selena Deckelmann | 56m |
Uses Alembic + SQLAlchemy against Postgres to turn chaotic SQL-and-bash migrations into an automated, reviewable pipeline with CI and a full 1.5 terabyte… | ||
| Postgres What They Really Use | Craig Kerstiens | 45m |
Heroku reports running over a billion transactions a day and breaks out actual usage: 17% of production databases enable extensions (about 22% of those use… | ||
| Postgres-XC dynamic cluster managment | Koichi Suzuki | 58m |
Demonstration builds a running Postgres‑XC cluster (version 1.1) with four coordinators and four data nodes (16 instances), deploys binaries to new hosts, and… | ||
| Federating Queries Using postgres_fdw | John Melesky | 54m |
Sets up postgres_fdw on PostgreSQL 9.3, creates foreign servers, user mappings and foreign tables, then federates with union all views over eight nodes in a… | ||
| Managing PostgreSQL with Puppet | Steve Singer | 55m |
Afilias uses Puppet plus a Git workflow and Hiera to install and configure PostgreSQL at scale, managing over 100 production database servers, replicas via… | ||
| My Experience with Embedding PostgresSQL | Jignesh Shah | 45m |
VMware embeds PostgreSQL across roughly 30 products (about 20 requiring databases) to eliminate external license costs and ships an embedded DB-as-a-service… | ||
| Concurrency in Postgres | Peter V Geoghegan | 58m |
Explains exactly which SQL isolation levels map to which visibility rules and guarantees and shows the specific locks acquired on tables indexes rows… | ||
| New Approach to Resolve objectrelational impedance mismatch | Henrietta Dombrovaskaya | 01h 01m |
Shows concrete wins: Ruby on Rails with Active Record and Postgres is generating 1,000 database calls per screen for some controllers, identified by PG Badger… | ||
| Case Study, Converting the CATME application from MySQL to Postgres | Julier Baumler | 57m |
Converting CATME from MySQL to Postgres uses concrete, repeatable steps: run automated sed awk Perl scripts to rewrite about 80–90% of SQL, handle manual… | ||
| Lightning Talks | Catherine Devlin, Inés Sombra, Tom Kincaid, Kirk Roybal, Denish Patel, Jonathan S. Katz, Mark Mzyk, Greg Smith, Mark Wong | 51m |
Ten five‑to‑seven minute demos show concrete tools and outcomes not vague topics. Look for IPython SQL + pandas workflow that runs SQL via SQLAlchemy, assigns… | ||
| Postgres Plus Cloud Database | Hans Hrasna | 41m |
Postgres Plus Cloud Database claims a runnable PostgreSQL cluster in 10 seconds using jclouds for IaaS calls and jgroups for cluster management, auto-scaling… | ||
| Writing Portable PostgreSQL - backed network applications for the open cloud | Ryan Jarvinen | 01h 00m |
Claims that a PostgreSQL app can be shifted from GitHub into OpenShift are backed by the actual commands and limits shown: use rhc app create with a cartridge… | ||
| JackDB Database Development in your web browser | Sehrope Sarkuni | 52m |
A web-based SQL client and proxy that actually centralizes connections, tags every statement with the real user for query audit, and claims 18 seconds to… | ||
| Inside PostgreSQL Shared Memory | Bruce Momjian | 50m |
Explains concrete internals: data files live on the file system, rows packed into 8k pages with headers item pointers and a null bitmap (t‑bits), and primary… | ||
| Geographically Distributed Prallel Databases - A Reality! | Christine Normile | 36m |
TransLattice delivers a runnable geographically distributed OLTP database built as one ISO/OVA on Postgres92 + Postgres‑R with proprietary networking and… | ||
| How Postgres is Different (read BETTER than) your database | Gurjeet Singh | 51m |
Claims that PostgreSQL can replace Oracle/DB2 for enterprise workloads, and that it behaves as a platform not just a database, are supported by concrete… | ||
| Replication Refresh | Simon Riggs | 48m |
PostgreSQL 9.3 adds concrete replication behavior: physical WAL streaming with hot standby read-only queries, per-transaction durability levels (including… | ||
| When Postgres Can't, You Can! | Keith Fiske | 51m |
Provides concrete hacks and extensions that actually run in production at millions of users and terabytes of data: PG extractor uses pg_dump + pg_restore (and… | ||
| Multi Database Colaboration and Extract - Transform - Load with HTSQL | Clark C Evans | 47m |
HTSQL now carries ETL features that let data analysts compose navigational queries, test them incrementally, and then run an insert‑update merge that does… | ||
| A comparison of PostgreSQL Encryption Options | Syed Faisal Akber | 29m |
Promises a survey of encryption approaches but only useful if it states precise claims: which ciphers and key lengths are supported, whether pgcrypto or TDE or… | ||
| Using Postgres FDW with a sharded PostgreSQL Database | Stephen Frost | 51m |
Shows how Postgres FDW links a 32-way sharded PostgreSQL setup (run on eight physical boxes) by creating foreign servers, per-server user mappings, and union… | ||
| SQl Database Server Request from the Browser | David Keeney | 47m |
Claims a working API that lets browser JavaScript issue real PostgreSQL SQL securely, demonstrates a hosted proxy that enforces per-query roles and… | ||
| Using JSON with Postgres 9 3 | Andrew Dunstan | 50m |
PostgreSQL 9.3 adds concrete JSON generators, extractors and an extendable parsing API so code actually produces and queries JSON instead of treating blobs as… | ||
| PostgreSQL on ZFS | Keith Paskett | 51m |
ZFS provides instant snapshot pointers that let Postgres get point‑in‑time clones without copying data, snapshots incur near‑zero runtime impact, and clones… | ||
| PostgreSQL Backup and Recovery Methods | Kevin Kempter | 50m |
Covers concrete commands and tradeoffs: use pg_dump/pg_restore (plain, tar, custom), dump-only-schema or data, create list files to omit objects, and run… | ||
| Scalable Uniques in Postgres - HyperLogLog | Craig Kerstiens | 12m |
Shows how the postgresql-hll extension implements HyperLogLog inside Postgres to count uniques, claiming a 280 bytes sketch can estimate tens of billions of… | ||
| NewSQL Leveraging PostgreSQL | John S Jones | 12m |
Claims that NewSQL keeps SQL and ACID while adding non‑locking concurrency, scale‑out shared‑nothing performance, and elasticity. Examples: PostgreSQL appears… | ||
| Secure Your Web Webapp passwords in PostgreSQL | Magnus Hagander | 24m |
Outlines a concrete design: rename the user table to a shadow table, revoke select on shadow from the web role, expose a trimmed view with nulled secrets, and… | ||
| nothing matches | ||