Upcoming presentations
No upcoming presentations...
Past presentations
- Some techniques may outright lie to you. ...
Postgres in the Containers Era
The Future; and the Present; is to run Postgres on Containers
Containers are everywhere. Whether in a code test suite, a developer's laptop, in production or CI/CD pipelines, containers have taken the deployment world by storm. Similarly, Kubernetes adoption is skyrocketing.
How does Postgres fit in this container era? Is Postgres "cloud native"?
The challenges to optimally run Postgres in containers will be explored, including the challenges associ...
How to measure query performance
Or, alternatively, how NOT to measure query performance
If you don’t know how to measure query performance in Postgres, this talk is for you.
If you know how to do it and consider it a simple and solved problem, this talk is definitely for you.
It doesn’t sound too complicated. There are several tools and techniques to report query performance. But a deeper look reveals some troubling conclusions:
Today, running Postgres on Kubernetes is not out of the ordinary. But given all of Kubernetes capabilities, doing a 1:1 between how you run Postgres on Kubernetes and how you run it outside of it is a loss of opportunity.
The Open-Source StackGres (https://stackgres.io) project has leveraged Kubernetes API to its fullest to make Postgres not run, but fly, on Kubernetes! Join this webinar w...
There is no protection against bad queries. If a query is poorly written, it's execution can't be improved with any indexes, fast access path or other database advancements. What is the most common source of poorly written queries? Most of the time they do not come from humans; they are generated by applications that use ORMs to communicate with databases. What can we do to prevent it from happ...
StackGres: Cloud-Native PostgreSQL on Kubernetes
Your secret trick to have a PosgreSQL-as-a-Service in your own infra
An enterprise-grade PostgreSQL requires many complementary technologies to the database core: high availability and automated failover, monitoring and alerting, centralized logging, connection pooling, etc. That is, a stack of components around PostgreSQL.
Kubernetes has enabled a new model to deploy software abstracting away the infrastructure. However, containers are not lightweigh...
Oracle to PostgreSQL Migration Tutorial
Stop paying for Larry’s boat!
PostgreSQL is a fully-featured, enterprise-grade and open source database, named two years in a row database of the year! And it’s also the best candidate to migrate off of Oracle, supporting very advanced SQL, easy administration and pl/pgsql, a replacement for Oracle’s PL/SQL. Stop spending hundreds of thousands or millions of $ on database licenses and reinvest them in your team, infrastru...
Oracle to PostgreSQL Migration Tutorial
Hands On Labs
Stop paying for Larry’s boat!
PostgreSQL is a fully-featured, enterprise-grade and open source database, named two years in a row database of the year! And it’s also the best candidate to migrate off of Oracle, supporting very advanced SQL, easy administration and pl/pgsql, a replacement for Oracle’s PL/SQL. Stop spending hundreds of thousands or millions of $ on database licenses and rein...
Tutorial on Modern PostgreSQL High Availability
BYOL -- Bring Your Own Laptop!
It’s 3am. Your phone rings. PostgreSQL is down, you need to promote a replica to master. Why the h**l isn’t this automatic?
If you thought of this before, you want automatic High Availability (HA). Don’t miss this tutorial! We will enter the world of Modern PostgreSQL HA.
Good news, there are several new, “modern” solutions for PostgreSQL HA. However, there are several solutions and it's ...
PostgreSQL Configuration for Humans
AI tuning is not ready yet
PostgreSQL is the world’s most advanced open source database. Indeed! With around 270 configuration parameters in postgresql.conf, plus all the knobs in pg_hba.conf, it is definitely ADVANCED!
How many parameters do you tune? 1? 8? 32? Anyone ever tuned more than 64?
No tuning means below par performance. But how to start? Which parameters to tune? What are the appropriate values? Is ther...
Hydra geo-redundant failover for Postgresql
geo-redundancy in Groupon
PostgreSQL High Availability (HA) is a very desirable goal for most, if not a strict requirement. And there are technologies and literature to help provide HA on a PostgreSQL cluster.
However at Groupon we manage hundreds of database servers, distributed across several datacenters in the world. And our internal policy mandates that we need a Disaster Recovery mechanism to switch a complete d...