Канал: Postgres Open

PostgresOpen 2019 Optimizing Query Performance

PostgresOpen 2019 Optimizing Query Performance

PostgresOpen 2019 Mistaken And Ignored Parameters While Optimizing A PostgreSQL Database

PostgresOpen 2019 Mistaken And Ignored Parameters While Optimizing A PostgreSQL Database

PostgresOpen 2019 Amazing SQL

PostgresOpen 2019 Amazing SQL

PostgresOpen 2019 Advanced Data Types In PostgreSQL

PostgresOpen 2019 Advanced Data Types In PostgreSQL

PostgresOpen 2019 A Look At The Elephants Trunk

PostgresOpen 2019 A Look At The Elephants Trunk

PostgresOpen 2019 Fibonacci Spirals 21 Ways To Contribute To Postgres Beyond Code

PostgresOpen 2019 Fibonacci Spirals 21 Ways To Contribute To Postgres Beyond Code

PostgresOpen 2019 Fascinating Reporting With Postgres psql

PostgresOpen 2019 Fascinating Reporting With Postgres psql

PostgresOpen 2019 Explain Plans And You

PostgresOpen 2019 Explain Plans And You

PostgresOpen 2019 Evolving Towards Postgres

PostgresOpen 2019 Evolving Towards Postgres

PostgresOpen 2019 EnterpriseDB Keynote

PostgresOpen 2019 EnterpriseDB Keynote

PostgresOpen 2019 Easy And Correct High Availability PostgreSQL With Kubernetes

PostgresOpen 2019 Easy And Correct High Availability PostgreSQL With Kubernetes

PostgresOpen 2019 Data Modeling Normalization And Denormalization

PostgresOpen 2019 Data Modeling Normalization And Denormalization

PostgresOpen 2019 Combating Imposter Syndrome

PostgresOpen 2019 Combating Imposter Syndrome

PostgresOpen 2019 Closing

PostgresOpen 2019 Closing

PostgresOpen 2019 JSONB Tricks

PostgresOpen 2019 JSONB Tricks

PostgresOpen 2019 Intro To Foreign Data Wrappers In Postgres

PostgresOpen 2019 Intro To Foreign Data Wrappers In Postgres

PostgresOpen 2019 Improve Your SQL Workload With Observability

PostgresOpen 2019 Improve Your SQL Workload With Observability

PostgresOpen 2019 I Didn't Know Postgres Could Do That

PostgresOpen 2019 I Didn't Know Postgres Could Do That

PostgresOpen 2019 How To Make Resilient Microservices With A PostgreSQL Dependency

PostgresOpen 2019 How To Make Resilient Microservices With A PostgreSQL Dependency

PostgresOpen 2019 How And Why Of Method Chaining With SQLAlchemy In PostgreSQL

PostgresOpen 2019 How And Why Of Method Chaining With SQLAlchemy In PostgreSQL

PostgresOpen 2019 Heroku Keynote

PostgresOpen 2019 Heroku Keynote

PostgresOpen 2019 Help My Database Is Empty

PostgresOpen 2019 Help My Database Is Empty

PostgresOpen 2019 Good Data Gone Bad

PostgresOpen 2019 Good Data Gone Bad

PostgresOpen 2019 Microsoft Keynote

PostgresOpen 2019 Microsoft Keynote

PostgresOpen 2019 Meet NULL The Unknown

PostgresOpen 2019 Meet NULL The Unknown

PostgresOpen 2019 Making Use Of The Turing Completeness Of SQL

PostgresOpen 2019 Making Use Of The Turing Completeness Of SQL

PostgresOpen 2019 Look It Up Practical PostgreSQL Indexing

PostgresOpen 2019 Look It Up Practical PostgreSQL Indexing

PostgresOpen 2019 PostgreSQL Under Windows

PostgresOpen 2019 PostgreSQL Under Windows

PostgresOpen 2019 PostgreSQL Partitioning

PostgresOpen 2019 PostgreSQL Partitioning

PostgresOpen 2019 PostgreSQL Extensions A Deeper Dive

PostgresOpen 2019 PostgreSQL Extensions A Deeper Dive

PostgresOpen 2019 Upgrade All The Things

PostgresOpen 2019 Upgrade All The Things

PostgresOpen 2019 The Art Of PostgreSQL

PostgresOpen 2019 The Art Of PostgreSQL

PostgresOpen 2019 The Adventures Of MySQL FDW

PostgresOpen 2019 The Adventures Of MySQL FDW

PostgresOpen 2019 Terminal Tools For Displaying PostgreSQL Statistics

PostgresOpen 2019 Terminal Tools For Displaying PostgreSQL Statistics

PostgresOpen 2019 Sustaining Community As A Black Woman

PostgresOpen 2019 Sustaining Community As A Black Woman

PostgresOpen 2019 Recovering From A Split Brain

PostgresOpen 2019 Recovering From A Split Brain

PostgresOpen 2019 PostgreSQLs IO Subsystem

PostgresOpen 2019 PostgreSQLs IO Subsystem

PostgresOpen 2019 Welcome

PostgresOpen 2019 Welcome

Cleaning out crocodiles teeth with PostgreSQL indexes - a story on all the index types in PG

Cleaning out crocodiles teeth with PostgreSQL indexes - a story on all the index types in PG

Don't Panic: Use the PostgreSQL Operator for Kubernetes and OpenShift

Don't Panic: Use the PostgreSQL Operator for Kubernetes and OpenShift

Parallelism in PostgreSQL 11

Parallelism in PostgreSQL 11

How to Monitor Your Database

How to Monitor Your Database

A look at the Elephants trunk - PostgreSQL 11

A look at the Elephants trunk - PostgreSQL 11

PostgreSQL Locking Issues: a talk for devs and DBAs

PostgreSQL Locking Issues: a talk for devs and DBAs

Just in time compilation in PostgreSQL

Just in time compilation in PostgreSQL

Computational Complexity and the Query Planner

Computational Complexity and the Query Planner

Hacking with PostgreSQL for fun and not so much profit

Hacking with PostgreSQL for fun and not so much profit

Hypothetical Partitioning for PostgreSQL

Hypothetical Partitioning for PostgreSQL

Using JSON in PostgreSQL

Using JSON in PostgreSQL

Spatial SQL: Put some "where" in your WHERE clause

Spatial SQL: Put some "where" in your WHERE clause

Hello Greenplum

Hello Greenplum

Connection Pooling 101

Connection Pooling 101

A New Hope for Database Migrations

A New Hope for Database Migrations

PostgreSQL Stored Procedures

PostgreSQL Stored Procedures

How PostgreSQL Extension APIs are Changing the Face of Relational Databases

How PostgreSQL Extension APIs are Changing the Face of Relational Databases

Building a real time analytics API at scale

Building a real time analytics API at scale

Crashing Postgres for Fun and Laughs

Crashing Postgres for Fun and Laughs

WAL: Everything you want to know

WAL: Everything you want to know

ANSI, Schmansi!

ANSI, Schmansi!

Lessons from building VeniceDB

Lessons from building VeniceDB

Debugging the Postgres Planner

Debugging the Postgres Planner

A scalable, versioned document store in PostgreSQL

A scalable, versioned document store in PostgreSQL

The Evolution of Postgres High Availability

The Evolution of Postgres High Availability

Dude, where's my byte?

Dude, where's my byte?

Bloat in PostgreSQL: A Taxonomy

Bloat in PostgreSQL: A Taxonomy

A look at the Elephant's Tail - Greg Stark

A look at the Elephant's Tail - Greg Stark

Efficiently Backing up Terabytes of Data with pgBackRest - David Steele

Efficiently Backing up Terabytes of Data with pgBackRest - David Steele

Data Architecture with PostgreSQL - Kevin Kempter

Data Architecture with PostgreSQL - Kevin Kempter

Using PostgreSQL in a Small Business - Preston Hagar

Using PostgreSQL in a Small Business - Preston Hagar

Bitemporal Data Model: Making it happened in Postgres- Chad Slaughter & Hennrietta Dombrovskaya

Bitemporal Data Model: Making it happened in Postgres- Chad Slaughter & Hennrietta Dombrovskaya

CREATE INDEX... USING RUM - Oleg Bartunov

CREATE INDEX... USING RUM - Oleg Bartunov

PostgreSQL Backups the modern ways - Magnus Hagander

PostgreSQL Backups the modern ways - Magnus Hagander

Using PostGIS to Handle Geospatial Data - Dylan Herron

Using PostGIS to Handle Geospatial Data - Dylan Herron

JDBC Performance from the Inside - Dave Cramer

JDBC Performance from the Inside - Dave Cramer

Understanding Durability in Postgres - Andres Freund

Understanding Durability in Postgres - Andres Freund

Assume database credentials have leaked - Sean Chittenden

Assume database credentials have leaked - Sean Chittenden

Locked Up: Advances in Postgres Data Encryption - Vibhor Kumar

Locked Up: Advances in Postgres Data Encryption - Vibhor Kumar

Shall We Play a Game? (with CTEs) - James Coleman

Shall We Play a Game? (with CTEs) - James Coleman

Data Analysis with PL/Python - Keith Robertson

Data Analysis with PL/Python - Keith Robertson

PGLogical - The logical replication for PostgreSQL - Petr Jelinek

PGLogical - The logical replication for PostgreSQL - Petr Jelinek

An opinionated guide to POstgreSQL replication - Peter Eisentraut

An opinionated guide to POstgreSQL replication - Peter Eisentraut

PostgreSQL Worst Practices - Ilya Kosmodemiansky

PostgreSQL Worst Practices - Ilya Kosmodemiansky

Big data with PostgreSQL - Simon Riggs

Big data with PostgreSQL - Simon Riggs

A look at the Elephant's Trunk - PostgreSQL 9.6 - Magnus Hagander

A look at the Elephant's Trunk - PostgreSQL 9.6 - Magnus Hagander

Your database migrations are bad and you should feel bad

Your database migrations are bad and you should feel bad

PostgreSQL Security for Application Developers

PostgreSQL Security for Application Developers

PostgreSQL at Pandora

PostgreSQL at Pandora

PostgreSQL as a distributed computing platform

PostgreSQL as a distributed computing platform

A Kubernetes Operator for PostgreSQL - Architecture and Design

A Kubernetes Operator for PostgreSQL - Architecture and Design

ETL Confessions

ETL Confessions

Monitoring 101

Monitoring 101

Get to know Google Cloud SQL

Get to know Google Cloud SQL

Distributed COUNT(DISTINCT) with HyperLogLog on PostgreSQL

Distributed COUNT(DISTINCT) with HyperLogLog on PostgreSQL

Best practices of using a managed PostgreSQL in the cloud

Best practices of using a managed PostgreSQL in the cloud

Developing powerful and intelligent apps using the Azure managed PostgreSQL service

Developing powerful and intelligent apps using the Azure managed PostgreSQL service

PostgreSQL, REST API's and Rapid Application Development for Legacy Data

PostgreSQL, REST API's and Rapid Application Development for Legacy Data

Scalable in-database machine learning with PL/Python

Scalable in-database machine learning with PL/Python

Scaling a Saas application beyond a single Postgres with Citus

Scaling a Saas application beyond a single Postgres with Citus

The Immortal Postgres Web

The Immortal Postgres Web

Enhancements to the bitemporal model support: integrity constraints

Enhancements to the bitemporal model support: integrity constraints

Beyond Foreign Data Wrappers: building a data warehouse from heterogeneous external data sources

Beyond Foreign Data Wrappers: building a data warehouse from heterogeneous external data sources

Securing PostgreSQL - Exploring the PostgreSQL STIG and Beyond

Securing PostgreSQL - Exploring the PostgreSQL STIG and Beyond

PostgreSQL BI Performance & News from XL project

PostgreSQL BI Performance & News from XL project

Improving Postgres' Efficiency

Improving Postgres' Efficiency

Human Beings Do Not Have A Primary Key

Human Beings Do Not Have A Primary Key

Concurrency Deep-Dive

Concurrency Deep-Dive

Tuning PostgreSQL for High Write Workloads

Tuning PostgreSQL for High Write Workloads

Replication based Multi-Master solutions and design patterns

Replication based Multi-Master solutions and design patterns

PastgreSQL: Dead data tells all tales!

PastgreSQL: Dead data tells all tales!

PanLex: Using PostgreSQL to implement a massive word-translation graph

PanLex: Using PostgreSQL to implement a massive word-translation graph

Logical Replication...LIVE!

Logical Replication...LIVE!

How Postgres could index itself

How Postgres could index itself

An ultimate guide to upgrading your PostgreSQL installation

An ultimate guide to upgrading your PostgreSQL installation

Schrodinger's Elephant

Schrodinger's Elephant

Postgres Window Magic

Postgres Window Magic

PgBouncer and 20000 TPS at one node: advanced tuning, hacks and problem solving

PgBouncer and 20000 TPS at one node: advanced tuning, hacks and problem solving

Welcome - Stephen Frost, Co-chair, PostgresOpen SV 2017

Welcome - Stephen Frost, Co-chair, PostgresOpen SV 2017

Guest Keynote - Paul Vixie

Guest Keynote - Paul Vixie

Keynote - Simon Riggs, Founder & CTO, 2ndQuadrant

Keynote - Simon Riggs, Founder & CTO, 2ndQuadrant

Keynote - Rohan Kumar, General Manager, Microsoft

Keynote - Rohan Kumar, General Manager, Microsoft

Keynote - Ozgun Erdogan, Co-founder & Marco Slot, Citus Data

Keynote - Ozgun Erdogan, Co-founder & Marco Slot, Citus Data

A look at the elephant's trunk - PostgreSQL 10

A look at the elephant's trunk - PostgreSQL 10

Postgres Open 2016 - The Elephant Meets the Whale

Postgres Open 2016 - The Elephant Meets the Whale

Postgres Open 2016 - Elephant Herd as a Service

Postgres Open 2016 - Elephant Herd as a Service

Postgres Open 2016 - Permissions in Postgres

Postgres Open 2016 - Permissions in Postgres

Postgres Open 2016 - Performance Improvements in PostgreSQL 9.5, 9.6 and beyond

Postgres Open 2016 - Performance Improvements in PostgreSQL 9.5, 9.6 and beyond

Postgres Open 2016 - All the Big Data Sciency stuff you never knew Postgres could do

Postgres Open 2016 - All the Big Data Sciency stuff you never knew Postgres could do

Postgres Open 2016 - Reviewing PostgreSQL Patches for Fun and Profit

Postgres Open 2016 - Reviewing PostgreSQL Patches for Fun and Profit

Postgres Open 2016 - Advanced Postgres Monitoring

Postgres Open 2016 - Advanced Postgres Monitoring

Postgres Open 2016 - Flexible Indexing with Postgres

Postgres Open 2016 - Flexible Indexing with Postgres

Postgres Open 2016 - Non-Relational Postgres

Postgres Open 2016 - Non-Relational Postgres

Postgres Open 2016 - PostgreSQL with Chef & Puppet

Postgres Open 2016 - PostgreSQL with Chef & Puppet

Postgres Open 2016 - Administering Postgres using Docker and Openshift

Postgres Open 2016 - Administering Postgres using Docker and Openshift

Postgres Open 2016 - Amazon RDS for PostgreSQL: New Features and Lessons Learned

Postgres Open 2016 - Amazon RDS for PostgreSQL: New Features and Lessons Learned

Postgres Open 2016 LightningTalks

Postgres Open 2016 LightningTalks

Postgres Open 2016 - Identifying Slow Queries and Fixing Them!

Postgres Open 2016 - Identifying Slow Queries and Fixing Them!

Postgres Open 2016 - Managing OS Provided PostgreSQL Packages

Postgres Open 2016 - Managing OS Provided PostgreSQL Packages

Postgres Open 2016 - 2nd Quadrant Keynote Address from Simon Riggs

Postgres Open 2016 - 2nd Quadrant Keynote Address from Simon Riggs

All The Dirt On Vacuum - Jim Nasby

All The Dirt On Vacuum - Jim Nasby

UPSERT Use Cases - Peter Geoghegan

UPSERT Use Cases - Peter Geoghegan

SQL Metacode System - Jon Erdman

SQL Metacode System - Jon Erdman

Streaming SQL With PipelineDB - Derek Nelson

Streaming SQL With PipelineDB - Derek Nelson

Searching Text With PostgreSQL - Phil Vacca

Searching Text With PostgreSQL - Phil Vacca

PostgreSQL Service At Scale - Sean Chittenden

PostgreSQL Service At Scale - Sean Chittenden

PostgreSQL Scalability - Simon Riggs

PostgreSQL Scalability - Simon Riggs

PostgreSQL Performance Benchmarking - Mark Wong

PostgreSQL Performance Benchmarking - Mark Wong

PostgreSQL In PaxosLand - Srivathsava Rangarajan

PostgreSQL In PaxosLand - Srivathsava Rangarajan

PostgreSQL In Critical Messaging - John Mason Scott

PostgreSQL In Critical Messaging - John Mason Scott

PostgreSQL Containers At Scale - Jeff McCormick and Steven Pousty

PostgreSQL Containers At Scale - Jeff McCormick and Steven Pousty

PostgreSQL And Amazon RDS McAlister

PostgreSQL And Amazon RDS McAlister

Measurements, scales and encoding schemes - Joe Celko

Measurements, scales and encoding schemes - Joe Celko

Pacemaker And PostgreSQL - Brian Cosgrove

Pacemaker And PostgreSQL - Brian Cosgrove

The Bones of Highly Available Postgres - Shaun Thomas

The Bones of Highly Available Postgres - Shaun Thomas

Don't Forget The Elephant - Keith Fiske

Don't Forget The Elephant - Keith Fiske

Database Hardware Selection Guidelines - Bruce Momjian

Database Hardware Selection Guidelines - Bruce Momjian

BDR From the Perspective of a QA Engineer - Simon Riggs

BDR From the Perspective of a QA Engineer - Simon Riggs

Closing Session - Stephen Frost

Closing Session - Stephen Frost

What's new in PostgreSQL 9.5 - Magnus Hagander

What's new in PostgreSQL 9.5 - Magnus Hagander

A TARDIS for your ORM - Magnus Hagander

A TARDIS for your ORM - Magnus Hagander

Welcome to Postgres! - Michael Alan Brewer

Welcome to Postgres! - Michael Alan Brewer

WAL, standbys and Postgres 9.5 - Michael Paquier

WAL, standbys and Postgres 9.5 - Michael Paquier

Using Postgres XL - Richard Silva

Using Postgres XL - Richard Silva

Securing Your Database in Amazon RDS - Sarah Conway

Securing Your Database in Amazon RDS - Sarah Conway

PostgreSQL Federation - Jim Mlodgenski

PostgreSQL Federation - Jim Mlodgenski

PostgreSQL Administration - Simon Riggs

PostgreSQL Administration - Simon Riggs

Monitoring PostgreSQL - Kevin Kempter

Monitoring PostgreSQL - Kevin Kempter

Logical Decoding - Alvaro Hernandez

Logical Decoding - Alvaro Hernandez

Lightning Talks

Lightning Talks

Keynote - Lacey Williams Henschel

Keynote - Lacey Williams Henschel

Improving Postgres' Concurrency - Andres Freund

Improving Postgres' Concurrency - Andres Freund

Explain Explained - Josh Berkus

Explain Explained - Josh Berkus

Easy Statistical Analysis - Joe Conway

Easy Statistical Analysis - Joe Conway

Becoming a SQL Guru - Stella Nisenbaum

Becoming a SQL Guru - Stella Nisenbaum

Audit Logging For PostgreSQL - David Steele

Audit Logging For PostgreSQL - David Steele

Amazon RDS for PostgreSQL - Grant McAlister

Amazon RDS for PostgreSQL - Grant McAlister

Welcome - Stephen Frost

Welcome - Stephen Frost

Explaining the Postgres Query Optimizer - Bruce Momjian

Explaining the Postgres Query Optimizer - Bruce Momjian

Who's the Fairest of Them All? Postgres Interface Performance - Joe Conway

Who's the Fairest of Them All? Postgres Interface Performance - Joe Conway

Automated Performance Testing of Postgres - Greg Burek

Automated Performance Testing of Postgres - Greg Burek

Scalability, Consistency, Replication, Availability and Performance - Simon Riggs

Scalability, Consistency, Replication, Availability and Performance - Simon Riggs

PostgreSQL for Developers - Dimitri Fontaine

PostgreSQL for Developers - Dimitri Fontaine

PostgreSQL Scale-Out at inMobi - Sivakumar

PostgreSQL Scale-Out at inMobi - Sivakumar

On Beyond Data Types - Jonathan Katz

On Beyond Data Types - Jonathan Katz

PostgreSQL and Java: Best Practices - Alvaro Hernandez

PostgreSQL and Java: Best Practices - Alvaro Hernandez

Sponsor Keynote #2 - Simon Riggs

Sponsor Keynote #2 - Simon Riggs

Understanding Logical Decoding and Replication - Michael Paquier

Understanding Logical Decoding and Replication - Michael Paquier

Row Level Security - Stephen Frost

Row Level Security - Stephen Frost

Postgres in Amazon RDS - Denish Patel

Postgres in Amazon RDS - Denish Patel

What's New in PostgreSQL 9.4 - Magnus Hagander

What's New in PostgreSQL 9.4 - Magnus Hagander

The NoSQL Way in PostgreSQL - Vibhor Kumar

The NoSQL Way in PostgreSQL - Vibhor Kumar

Survival Analysis of Customer Retention using Postgres, SQL and R - Gleb Arshinov

Survival Analysis of Customer Retention using Postgres, SQL and R - Gleb Arshinov

Supersized Postgres: Postgres-XL for OLTP and Big Data Analytics - Mason Sharp

Supersized Postgres: Postgres-XL for OLTP and Big Data Analytics - Mason Sharp

PoastgreSQL Auditing, Authentication, and Security - Sehrope Sarkuni

PoastgreSQL Auditing, Authentication, and Security - Sehrope Sarkuni

Collectd and Graphite: Monitoring PostgreSQL w/Style - Shaun Thomas

Collectd and Graphite: Monitoring PostgreSQL w/Style - Shaun Thomas

Heavy Duty Backup w/PgBackRest - David Steele

Heavy Duty Backup w/PgBackRest - David Steele

Row-Estimation Revelation and the Monolithic Query Syndrome - Jeff Amiel

Row-Estimation Revelation and the Monolithic Query Syndrome - Jeff Amiel

Holistic Database Application Tuning - Grant Evans, Henrietta Dombrovskaya

Holistic Database Application Tuning - Grant Evans, Henrietta Dombrovskaya

The Three Musketeers (Authentication, Authorization, and Accounting) - Sarah Conway

The Three Musketeers (Authentication, Authorization, and Accounting) - Sarah Conway

How Databases Work - For Developers, Accidental DBA's and Managers - Gurjeet Singh

How Databases Work - For Developers, Accidental DBA's and Managers - Gurjeet Singh

So you're new to Postgres... - Michael Alan Brewer

So you're new to Postgres... - Michael Alan Brewer