Postgres Conference 2020
Postgres Conference 2020 is the largest gathering about People, Postgres, Data! A professional, inclusive and diverse global event with a truly international community, we bring together a best-in-talent combination of speakers, attendees, and sponsors to build opportunities for the global Postgres ecosystem.
The registration period ends in
Some of our speakers
Are you facing performance problems? Well, if you do this is the perfect training class for you. You will be guided through PostgreSQL performance from the ground up and learn how to optimize your PostgreSQL database to achieve maximum performance under all circumstances. We will also point you to the most common bottlenecks and provide easy solutions to those problems.
Mar 27 postgresql.conf A-Z
We will take a full day trip to explore the postgresql.conf and explain all the interesting machinery behind those knobs - especially the additions in version 12.
Discover the new way of thinking about applications, IT processes, and systems in general using Kubernetes – the open source container orchestration platform. Join Simon Riggs, CEO of 2ndQuadrant, to receive an introduction to the platform for automating deployment, scaling, and operations of application containers across clusters of hosts. Starting with basics on Docker, the training course walks through the main concepts of using Kubernetes to deploy stateless applications on PostgreSQL...
Economic development research heavily relies on limited, expensive and sometimes “doubtful” survey data. Using free and readily available satellite imagery to empower economic development research is one solution to the problem. This talk will highlight some of those benefits and walk through a step-by-step technical example using open source tools. *source: NOAA.gov national oceanic and atmospheric administration Economists around the world often rely on limited survey data to...
This training will teach you how to use PostGIS related extensions to answer questions about WHERE and HOW TO GET THERE with data. The main focus will be on the postgis and pgrouting extensions as well as tools for loading spatial data. We will also cover techniques for getting the most performance out of your spatial and routing queries. Though most queries will also work on lower versions, we will be using PostgreSQL 12, PostGIS 3 , and pgRouting 3. We will highlight functions/spatial...
Mar 24 Postgres Talent Exchange
Career fair, Talent exchange, Speed Mentoring etc...
Join PostgreSQL Core Member and Committer, Bruce Momjian in exploring the current community efforts to bring a new standard of data privacy to PostgreSQL users. In this presentation we will talk about the status of current efforts, the expectations for the upcoming release of PostgreSQL 13 and future plans. We will also touch briefly on current security trends and where PostgreSQL needs to expand its efforts or where PostgreSQL already leads the industry.
Abstract: Is it possible to teach somebody to optimize? Or is optimization a sort of magic, available only for the limited circle of wizards? We believe that it is entirely possible to become an optimization wizard, and we are going to prove it in the course of this training. We will provide the participants with the opportunity to look at the process of query writing “as a database engine”, and will teach them “how to think, as a database engine”. The topics which will be covered...
In this tutorial we will be combining an extended deep dive on Amazon Relational Database Service along with a hands on lab using Amazon RDS for PostgreSQL. As part of the deep dive we will cover the unique features of Amazon RDS for improved availability and durability. In addition, you will get hands on experience creating an Amazon RDS for PostgreSQL for high availability and read scaling as well as point in time recovery for your instance. We will also walk through failover, promotion and...
In this session, we will highlight the operational best practices for running your Aurora clusters optimally and cost-effectively. You’ll also explore the latest features Aurora PostgreSQL has added for performance, operational management and security with hands-on labs. You’ll deploy a CloudFormation template that launches an Aurora cluster in a VPC and will configure and test new features such as Query plan management and CCM. Requirements: Please bring your laptop to get hands-on...
Amazon Aurora with PostgreSQL compatibility is a relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. In this session, we review the functionality in order to understand the architectural differences that contribute to improved scalability, availability, and durability. You'll also get a deep dive into the capabilities of the service and a review of the latest available...
What is the best solution to join 2 very big tables (>1TB) with billion rows and hundreds of columns with the help of distribution and partitioning? We have analysed different distribution and partition methods to achieve the best performance for a crossmatch, that is, identifying different rows from 2 tables (star catalogues) referring to the same star. Crossmatching helps scientists around the world to understand better our universe identifying objects observed by different space missions.
Kartoza is a South African company with a global footprint. We specialise in geospatial solutions with FOSS, which means we use PostGIS a lot. We also present courses on PostGIS. This workshop is a condensed version of what we normally do in two or three days. You will get hands-on experience with loading spatial data, understanding geometries and using spatial data in analysis. In the process you will learn all about spatial SQL and also how to use a desktop GIS (QGIS) to interact with the...
Developers are often challenged to deliver results that are hard to implement using simple SQL queries. Fortunately, complex SQL capabilities exist in the SQL standard --- common table expressions and window functions. SQL is a declarative language, meaning the user submits an SQL command and the database determines the optimal execution. Common Table Expressions (CTEs) allow queries to be more imperative, allowing looping and processing hierarchical structures that are normally...
Mar 24 Differentially Private SQL
Differential privacy (DP) provides formal guarantees that the output of a database query does not reveal too much information about any individual present in the database. While many differentially private algorithms have been proposed in the scientific literature, there are only a few end-to-end implementations of differentially private query engines. Crucially, existing systems assume that each individual is associated with at most one database record, which is unrealistic in...
Learn the ins and outs of running highly available Postrges on kubernetes for production. We will use Amazon EKS for orchestrating our kubernetes cluster.
As technology grows and evolves, it’s critical to have the best tech staff, yet not every business founder, project manager, or sales director has a tech background. How do you manage a team of developers, products and services when you don’t have tech experience? We'll explore this as well as - How do you bridge the knowledge gap between your technical team and your non-technical founders, project and product managers, and sales and marketing staff? - - How can you communicate...
This course will present the Postgres-BDR Always-On architecture. It will do an in depth review of logical replication and high availability concepts. How to achieve maximum availability through a Postgres Multi-Master architecture will presented. Specific topics that will be covered: 1) How to achieve zero down time upgrades. 2) How to quickly (under a second) failover. 3) How to failover between data data centers. 4) How to have a zero impact on your deployment as a result of...
has the most awesome program ever!
See rock-star speakers cover the topics of
PostgreSQL 13: The encrypted data platform for Regulated Industry by Bruce Momjian
Differentially Private SQL by Celia Zhang
IBM Cloud Hyper Protect DBaaS Delivers Complete Data Confidentiality by Colleen Gallagher
Enhancing the Car Buying Experience While Protecting Customer Data by Colleen Gallagher
Practical de-identification under the HIPAA Privacy Rule by Joseph Regensburger
Using PostgreSQL for Data Privacy and Security by Mason Sharp
A brief introduction to data privacy by Alfred Rossi
Ops and Administration
PostgreSQL performance from the ground up by Hans-Jürgen Schönig
postgresql.conf A-Z by Filip Rembiałkowski
Introduction to PostgreSQL and Kubernetes by Simon Riggs
High Availability and Automatic Failover in PostgreSQL. by Avinash Vallarapu
Make Your PostgreSQL 10x Faster on Cloud in Minutes by Sangwook Kim
pgagroal by Jesper Pedersen
PostgreSQL Extensions: A Deeper Look by Jignesh Shah
PostgreSQL Replication by Asif Rehman
Data Security in PostgreSQL - Deep Dive by Abbas Butt
PostgreSQL TDE: Fully encrypted PostgreSQL by Hans-Jürgen Schönig
Upgrading a PostgreSQL database from a legacy to newer version with no downtime. by Avinash Vallarapu
Running postgres on kubernetes by manish muttreja
Performance Impact of Idle PostgreSQL Connections by Yaser Raja
A detailed understanding of MVCC and Autovacuum Internals in PostgreSQL. by Avinash Vallarapu
Monitoring & Diagnostics of PostgreSQL by Mahadevan Ramachandran
Scalable Replication For Postgres by Marc Linster
Backup PostgreSQL with Barman by Andrew Dunstan
Scheduled PostgreSQL jobs with AWS Batch by Peter Celentano
Zero to Hero: Managing Postgres through DevOps by Ajay Patel
Postgres for the SQL Server DBA by Pat Wright
MVCC and Tuple Freezing through Pictures. by Tom Kincaid
Always-On with Postgres BDR (Deploying with Multi-Master) by Tom Kincaid
Wait! What's going on inside my database? Understanding PostgreSQL wait events by Jeremy Schneider
Backups, Upgrades, and Inventing a New Way to Move Data Faster by Jeremy Schneider
DevOps On ACID by Robert Treat
Upgrade Techniques Through the Ages by Shaun Thomas
Working with JSON Data in PostgreSQL vs. MongoDB by dharshan rangegowda
StackGres: Cloud-Native PostgreSQL on Kubernetes by Alvaro Hernandez
Turning PostgreSQL into a Cloud Native Data Service by Julian Fischer
The future of Postgres in a multi-cloud world by Marc Linster
From SQL Server DBA to Postgres DBA by Victoria McCormick
Monitor Postgres for performance by Ajay Patel
Tune your Linux Box, not just PostgreSQL by Ibrar Ahmed
Active Session History In PostgreSQL: Why?, How? and use cases by Bertrand Drouvot
Interesting 25 new features in PostgreSQL 12 by Jobin Augustine
WIP - AWS Serverless with PG driving everything by David Benoit
Will partitioning and sharding improve performance? by Pilar de Teodoro
Taking the Elephant By the Tusks by David Sudia
Working with spatial data in PostGIS by Gavin Fleming
A PostGIS portfolio by Gavin Fleming
The Great Escape: On Prem to the Cloud with Postgres by Morgan Howes
Postgresql at Gitlab.com by Jose Finotto
How did Postgres become best-fit for TomTom Maps? by Michał Gutkowski
Why PostgreSQL is Becoming a Migration Target in Large Enterprises by Jobin Augustine
Hyperscale your database with Azure Database for PostgreSQL by Bryan Dsouza
Omics data and PostgreSQL by Anson Abraham
Using PostgreSQL, PostGIS, and pgRouting for street sweeping by James E. Marca
Mass databases migrations to PostgreSQL at scale: Complexity study and migration by Bertrand Drouvot
Better late then never - Stored Procedures in PG 11 by Ahsan Hadi
Migrating from OpenTSDB to Timescale by Dan Wright
Migrating with Debezium by Mike Fowler
Data processing more than billion rows per second by Kohei KaiGai
Postgres In a world of Docker Containers by Shaktisikha Sahoo
Data Pipelines for Data as a Service (Wide Data) by Mara Lemagie
Postgres as a Graph Database by Greg Spiegelberg
The Parallel Retrieve Cursor by Wen Lin
Uncage the elephant: distributed postgresql by Stas Kelvich
YugabyteDB: a distributed PostgreSQL database by Bryn Llewellyn
Logical Replication Live! by Robert Treat
BDR Advanced Clustering & Scaling by Mark Wong
Using stored procedures effectively in a distributed PostgreSQL database by Bryn Llewellyn
Cross-site Replication for Massively Parallel Postgres by Shivram Mani
The Ultimate Postgres Optimization: Going Beyond Docs and Textbooks by Henrietta Dombrovskaya
Life without ORM: is it possible and how we can get there by Henrietta Dombrovskaya
Exploring Common Table Expressions and Window Functions by Bruce Momjian
Debugging with PostgreSQL by John Ashmead
Workshop to use Postgres and ArcGIS for beginners by Chaula Jain
B-tree indexes - learn more about the heart of PostgreSQL by Anastasia Lubennikova
Building the Holodeck by Justin Reock
Open Source Applied by Justin Reock
Tired of Impedence Mismatch? Meet Quill! by Alexander Ioffe
A Deep Dive into PostgreSQL Indexing by Ibrar Ahmed
Scaling AWS Redshift Concurrency With PostgreSQL by Will Liu
Building JSON from Relational Data by Jeremy Smith
The Art of Logical Replication by Kuntal Ghosh
Blockchain as a Database by Abdullah Uz Tansel
The anatomy of FTS engine in PostgreSQL. by Oleg Bartunov
Enterprise DDL Management by Gavin M. Roy
Customizing PostgreSQL via extensions by Rafia Sabih
Run Postgres Natively on Kubernetes by Marc Linster
Was Just About Time for JIT in PostgreSQL in v11 by Hamid Akhtar
MobilityDB: Managing Spatiotemporal Data in PostgreSQL by Mahmoud SAKR
Advanced compression in TimescaleDB with hybrid row/columnar storage by Michael Freedman
Professional Development, Life and Leadership
Being An Effective Tech Leader by Debra Cerda
Speaking and Community Involvement for the Introvert by Pat Wright
Career Panel by Mara Lemagie
How to build local communities: a meetup perspective by Henrietta Dombrovskaya
Be the Change: Fostering Inclusion through Allyship by Debra Cerda
How To Teach Beginners PostgreSQL, Painlessly by Mark Drake
A breakdown of the PostgreSQL ecosystem by John Hammink
Outside the Black Box by Rebecca Bilbro
Setting up PostgreSQL for Production in AWS by Scott Mead
Aurora PostgreSQL Operational Best Practices - Workshop by Kathy Gibbs
All the Dirt on Vacuum: RDS edition by Jim Nasby
Deep dive on Amazon Aurora with PostgreSQL compatibility by Grant McAlister
Accelerate Oracle to PostgreSQL Migration by David Rader