"Going green" as a company is commonly associated with unnecessary and high costs, causing many to overlook any accompanying benefits. In this talk, we'll cover steps you can take to both contribute towards a greener future, AND see an immediate return in cost savings & performance improvements.
Explore Apache Iceberg’s internals and its integration with PostgreSQL. Learn which extensions and tools enable PostgreSQL to thrive in Data Lakehouse architectures, with a brief glimpse into governance, security and privacy compliance, data quality, and AI use cases.
Turn disaster into opportunity! Learn from a real-world Postgres vacuum failure and discover how to prevent transaction wraparound catastrophes. Walk away with a deeper understanding of Postgres' inner workings and gain actionable insights to optimize your database and justify that next upgrade!
Managing the SKAO's massive data stream is a cosmic challenge. We'll explore how we harness PostgreSQL on kubernetes, with its powerful extensions and robust scaling, to process, store, and analyze the next generation of astronomical data, from correlator dumps to archived observations.
You want to use Postgres on containers (you should anyway!). And you want some extensions. But you don't want 200 extensions on your container image, with potentially security vulnerabilities from code you won't use.
How to have custom container images without having to create and maintain them?
PostgreSQL’s JSONB and MongoDB’s BSON both store JSON, but with very different designs. We’ll compare their strengths for document workloads across key aspects, highlighting where one excels and what the other could learn and improve.
The Transactional Outbox pattern is the common way to ensure events stay consistent between PostgreSQL and Kafka. In this talk, I’ll show how we implemented it with Debezium, turning WAL changes into reliable, low-latency Kafka events without custom polling jobs.
Postgres can act as a control plane, offloading compute to engines like Elasticsearch (ZomboDB) and TorchServe (PGML) while preserving SQL and ACID. This talk shares patterns, pitfalls, and checklists from building extensions that let Postgres orchestrate external compute engines.
While join and index use are interesting, there are many other things the Postgres optimizer can do, and this talk covers them all.
Database synchronization across heterogeneous systems is one of modern infrastructure's biggest challenges. This presentation introduces SynchDB, an open-source PostgreSQL extension enabling seamless CDC from MySQL, SQL Server, Oracle, and OpenLog Replicator to PostgreSQL.
PostgreSQL 18’s new cumulative stats system lets extension developers create custom statistics. This talk shows how PACS makes observability seamless, providing counters, gauges, buckets, and histograms integrated, similar to pg_stat_* views.
Moving to PostgreSQL? Testing matters. Motivated by customer needs, we sought a balance between updating existing tools or creating an extension. Join me as I share our pgTAP story, covering fundamentals, the wrapper we built, and why.
Unlock PostgreSQL's potential with **SQL AI Developer Copilot** and **DBA Copilot**. Generate optimized SQL, DDL, and procedural code tailored to your schema. Analyze queries, tune databases, and boost performance—all with AI-powered tools designed to streamline your PostgreSQL workflows.
The SQL standard defines 4 transaction isolation levels. What about PostgreSQL? Let's dig into each isolation level with practical examples and explain how each level is implemented under the hood. After this talk you should be able to choose confidently the right level for the right context.
This presentation will walk the audience through different approaches of monetizing and developing Open Source that have been used over the years. It will examine the pros and cons and the consequences of the newer SaaS models for the Open Source ecosystem.
By clicking on subscribe you agree to our privacy policy.