PostgresOpen Silicon Valley 2017
2017-09-06..2017-09-08
San Francisco, United States
| title | author | length |
|---|---|---|
| Welcome | Stephen Frost | 03m |
Announcements list roughly sixteen sponsors and partners by name including diamond sponsor SecondQuadrant, Microsoft as a new face, Heroku, VividCortex, Amazon… | ||
| Guest Keynote | Paul Vixie | 36m |
Describes adding inet/cidr types to Postgres95, then discovering a parsing bug and that the two types are accidentally swapped (inet allows zeros when cider… | ||
| Keynote | Simon Riggs | 20m |
Postgres 10 is shipping and the project lists logical replication with CREATE PUBLICATION/CREATE SUBSCRIPTION as a major feature; the logical decoding… | ||
| Keynote | Ozgun Erdogan, Marco Slot | 17m |
Announces Citus 7 with a concrete claim: Postgres extensions now support arbitrary distributed transactions across shards, including savepoints, sequences… | ||
| Keynote | Rohan Kumar | 08m |
Microsoft announces Azure Database for Postgres as a managed PaaS and commits to active community contribution, citing strong customer demand and engagement… | ||
| A look at the elephant's trunk - PostgreSQL 10 | Magnus Hagander | 50m |
Postgres 10 removes the dotted versioning and renames xlog paths/functions to WAL (so update scripts), defaults wal_level to replica and enables streaming and… | ||
| Postgres Window Magic | Bruce Momjian | 01h 06m |
A practical walkthrough of Postgres window functions that pins down actual behavior: defaults are range vs rows (default = range), order by changes what… | ||
| Schrodinger's Elephant | Josh Berkus | 44m |
Argues that containerizing Postgres buys portability and CI/CD convenience but exposes real limits: large databases hit the Linux OOM killer, default… | ||
| PgBouncer and 20000 TPS at one node: advanced tuning, hacks and problem solving | Victor Yagofarov | 44m |
Benchmarks show a single app machine hitting about 7,700 TPS with PgBouncer, and the architecture scales to ~20,000 TPS by running multiple coordinated… | ||
| An ultimate guide to upgrading your PostgreSQL installation | Ilya Kosmodemiansky | 46m |
Gives concrete upgrade choices and actionable steps: use pg_dump -Fc or -Fd --jobs for reliable dump/restore (practical cutoff: several hundred GB), use… | ||
| PastgreSQL: Dead data tells all tales! | Samuel Elston, Srivathsava Rangarajan | 50m |
A Postgres auditing system called audit_star stores row images as a single JSON column generated by row triggers, deploys via a one‑line Go tool across… | ||
| PanLex: Using PostgreSQL to implement a massive word-translation graph | David Kamholz | 48m |
PanLex uses PostgreSQL to store ~25 million expressions from >2,500 resources across ~5,700 language varieties and yields 1.3 billion direct translations from… | ||
| Tuning PostgreSQL for High Write Workloads | Grant McAlister | 43m |
Starts with a 9-index test table (UUID PK, many random columns) that peaks ~25k TPS then collapses; updates run ~3.7k TPS. Major causes are full-page writes… | ||
| Replication based Multi-Master solutions and design patterns | Tom Kincaid | 50m |
Describes a WAL‑based mesh that implements BDR logical replication to keep regional Postgres nodes (Tokyo, New York, Sydney) in sync, using node‑independent… | ||
| How Postgres could index itself | Andrew Kane | 37m |
Claim: Postgres can automatically recommend and create real indexes by combining query collection, planner simulation and hypothetical indexes. Implementation… | ||
| Logical Replication...LIVE! | Robert Treat | 59m |
Live demo of Postgres 10 logical replication shows how to set up publication/subscription pairs, enable WAL level = logical, and inspect replication slots… | ||
| Improving Postgres' Efficiency | Andres Freund | 50m |
Describes concrete Postgres changes and measured effects: adds multi-column statistics (Postgres 10) to fix huge selectivity errors, uses index-only scans and… | ||
| Securing PostgreSQL - Exploring the PostgreSQL STIG and Beyond | Joe Conway | 52m |
Postgres has an official Postgres STIG of 111 rules that targets RHEL7 and requires Postgres 9.5+ because many checks rely on PG Audit; the guide mandates… | ||
| Concurrency Deep-Dive | Tejas Manohar | 49m |
Postgres uses MVCC with per-row Xmin/Xmax transaction IDs (32-bit, monotonically increasing) and compare-and-swap to expire versions, so reads never block… | ||
| Human Beings Do Not Have A Primary Key | Christophe Pettus | 45m |
Claim: personal names are not database primary keys and common first/last fields break globally. Demonstrates APIs that demand first/last, credit-card… | ||
| PostgreSQL BI Performance & News from XL project | Mark Wong | 39m |
Benchmarks show vanilla Postgres improves modestly across 9.1–9.5 (~20%), then gains 3× speed on 10GB with 9.6 parallelism (22 TPC‑H queries drop to ~2–3… | ||
| The Immortal Postgres Web | Shaun Thomas | 50m |
Shows how to build a massively resilient Postgres web stack using HAProxy, Patroni, and ZooKeeper wired together: Patroni exposes a REST health port, ZooKeeper… | ||
| Scaling a Saas application beyond a single Postgres with Citus | Jesse H. Willett | 52m |
SaaS primary DB moves from a single Postgres (~0.7 TB) to Citus with 64 shards, a 60 GB coordinator and 661 GB data nodes totaling ~3.8 TB available; migration… | ||
| Scalable in-database machine learning with PL/Python | Srivatsan Ramanujam | 33m |
Shows how to run scikit learn models inside Postgres via PL/Python using a wine dataset to train a ridge regression on wine dataset and returns coefficients… | ||
| Enhancements to the bitemporal model support: integrity constraints | Boris Novikov, Chad Slaughter, Henrietta Dombrovskaya | 46m |
An open-source bitemporal layer for Postgres implements asserted-versioning time domains, an interval algebra and five temporal operations (insert, update… | ||
| Beyond Foreign Data Wrappers: building a data warehouse from heterogeneous external data sources | Chad Slaughter | 50m |
A practical recipe for building a Postgres-backed warehousing proxy that tests and loads heterogeneous third‑party sources: a dummy FDW handler lets CI… | ||
| PostgreSQL, REST API's and Rapid Application Development for Legacy Data | Charles Finley | 46m |
Demonstrates migrating diverse legacy data and apps into Postgres, exposing a working Postgres REST API and generating CRUD web/mobile clients with the… | ||
| Get to know Google Cloud SQL | Brett Hesterberg | 48m |
Managed Cloud SQL adds Postgres (9.6 beta) with automated minor upgrades, daily block-level snapshots kept seven days, and offloads integrity checks to… | ||
| Developing powerful and intelligent apps using the Azure managed PostgreSQL service | Sunil Kamath | 57m |
Overview of Azure managed PostgreSQL service: managed Postgres (9.5/9.6) is in preview since May and available in 13 regions, offers 35-day PITR with RPO <5… | ||
| Monitoring 101 | Jason Yee | 38m |
data dog claims it handles trillions of data points daily and uses Postgres with WAL‑E backups to provision read replicas quickly; alerting focuses on… | ||
| Best practices of using a managed PostgreSQL in the cloud | Jignesh Shah | 53m |
Managed PostgreSQL in the cloud locks down the OS with no SSH access and replaces root privileges with a limited superuser role while high‑level ops use the… | ||
| Distributed COUNT(DISTINCT) with HyperLogLog on PostgreSQL | Burak Yucesoy | 49m |
Distributed COUNT(DISTINCT) with HyperLogLog on PostgreSQL - Burak Yucesoy | ||
| A Kubernetes Operator for PostgreSQL - Architecture and Design | Sarah Conway | 43m |
A Kubernetes operator (pgo) that automates Postgres lifecycle tasks (create, backup, restore, clone, scale, upgrade) using a Go/Cobra CLI and the Kubernetes… | ||
| ETL Confessions | Corey Huinker | 46m |
Benchmarks show CSV loads of a 1.1 GB (5.6 million-row) file finish in 17–36 seconds depending on tool and table settings; PG bulkload and psql COPY perform… | ||
| PostgreSQL Security for Application Developers | Sehrope Sarkuni | 40m |
Recommends a concrete permission model: create read-only/DML/DDL split accounts, revoke public schema defaults and set default privileges so new tables inherit… | ||
| Your database migrations are bad and you should feel bad | Robert Lechte | 29m |
Argues that instead of accumulating numbered migration files, use a Postgres-aware diff tool: a command-line plus Python library called migrate that compares a… | ||
| PostgreSQL as a distributed computing platform | Marco Slot | 38m |
Argues PostgreSQL can act as a distributed platform and shows a working prototype: a 4-node Citus cluster with producers writing to a distributed events table… | ||
| PostgreSQL at Pandora | Stephen Rees | 51m |
Pandora migrates from Oracle to Postgres, defines five DBMS classes, and runs a music pipeline from Nexus ingestion to read‑only music metadata exports to a… | ||
| nothing matches | ||