Conference Highlights

Venkatesh Raghavan

Hadoop Can’t Query? (PostgreSQL Features)

With the explosion of data stores and cloud services, data now resides across many disparate systems and in a variety of formats. When multiple data sets exist in external systems, it is often necessary to perform a lengthy ETL (extract, transform, load) operation to get data into the database. But what if we only needed a small subset of the data? What if we only want to query the data to answer a specific question or to create a specific visualization? In this case, it's often more...

Lindsay Hooper

Aggregates in PGX: An Adventure

PostgreSQL provides a lot of functionality to create custom aggregates, a design feature that’s essential to the success of TimescaleDB. Our users often find themselves wanting to extend and build upon the aggregate functions we provide. However, the prospect of creating a performant aggregate function in C, along with the potential of being the long-term maintainer of a new function, can be a high barrier for many would-be contributors. But there’s great news! Not only does PGX help...

Joshua D. Drake

PostgreSQL v15

Join us for a live presentation (online) on an overview of the upcoming PostgreSQL v15 release!

Bhavin Shah

[Demo] Automating Migrations and Backups for PostgreSQL using Portworx

Portworx is a Kubernetes data-services platform that provides persistent storage, data protection, disaster recovery, and other capabilities for containerized applications. Portworx Data Services (PDS) builds upon and advances these capabilities by automating database deployment, management, and day-2 operations through a Database-as-a-Service platform for Kubernetes. Using Portworx allows the Orchestration of migrations and backups for PostgreSQL deployments. This demo will address...

Ivan Novick

Database Too Big to Query? What to do!

In this digital era, organizations heavily rely on data to make informed decisions day in and day out. Data-driven decision-making has become a norm in many organizations. Real-time analytics helps organizations make business-critical decisions which helps them to lower their TCO and also to stay ahead of their competition in the market. However, due to the increasing volume of data being generated by these organizations, it is becoming extremely difficult to manage the huge volume of data...

Grant Zhou

IvorySQL - An Open Source Oracle-compatible Database Based on PostgreSQL

There are many users who need to migrate their applications from Oracle to the open source Postgres, but in order to support the new database, users often need to re-develop the application, which is inconvenient. If there is a database based on Postgres and compatible with most Oracle syntax and functions, it will be too convenient for customers. However, the official Postgres project will not accept this kind of code submission. After all, Postgres is Postgres, and Oracle is Oracle. So,...

Franck Pachot

pg_hint_plan - get the right plan without surprises

I use pghintplan to learn about the optimizer, to understand the query planner choices, and, sometimes workaround a problem in production. But hinting is not easy. Fixing the exact plan needs more than one hint. In this live demo session, we will go through understanding and examples of how to use pghintplan in a predictable way. It is also a good occasion to understand the access paths, join order and methods, and how to read an execution plan

Franck Pachot

YugabyteDB, distributed PostgreSQL: why & how?

In the world of PostgreSQL compatible databases, a newcomer is YugabyteDB. Same protocol, similar open-source license, re-using postgres query layer but on a distributed storage plugged in place of heap tables and btree indexes. We will explain the reason for it, why it cannot be just an extension, and why it re-uses PostgreSQL. Similarities and differences, with an overview on the underlying technology: LSM Trees, distributed storage, logical clock, consensus protocols. The goal is to...