Register

presented by Greg Dostatni

Effective lock management is important for any database’s performance and stability. This presentation offers an exploration of some pitfalls and solutions to the Lock Manager challenges related to large, high performance environments.

We begin by examining how table inheritance can multiply the number of locks, and how that can affect performance when dealing with more than 10,000 locks. We will present quick way of converting inheritance based partition into native partitioning scheme. The discussion then extends to native partitions and how locks can affect data archiving and partition management on a busy system. This session then explores the impact of subtransactions on locking.

Join us to learn more about PostgreSQL’s Lock Manager challenges when running on a large, busy database. We will go over some practical queries for detecting and resolving these issues.

presented by Luigi Nardi

Join us at the Materialize offices for an engaging dialogue with Luigi Nardi of DBtune about automating your PostgreSQL database.

When automating and scaling your database, there are various approaches with their own unique benefits and risks. After automation, what outcomes can you anticipate for your database?

Parameter tuning in PostgreSQL databases is necessary yet complex. Engineers frequently opt for default settings in PostgreSQL rather than risk performance issues in their databases, which are vital infrastructure components for many organizations. Consequently, they can miss out on substantial performance enhancements.

In this fireside chat, we will discuss:

• Strategies for optimizing key aspects of tuning: Observation, analysis, and implementation
• Tuning techniques and best practices for dynamic workloads
• Enhancing permanence and parameter tuning in PostgreSQL with Machine Learning
• Harnessing Machine Learning to boost your database’s performance
• The advantages of automating segments of your database

presented by Randall Rhea

Join Google Cloud for a deep dive into AlloyDB Omni, the downloadable edition of AlloyDB. Get the best of both worlds: the familiarity of open source PostgreSQL with enterprise capabilities like superior performance, integrated analytics and gen AI, and full support from Google Cloud.

In this interactive session, you'll learn how to:

• Use AlloyDB Omni to migrate legacy databases to any location—whether on-premises or in any cloud
• Optimize your PostgreSQL deployments for performance and cost
• Get insights on your operational data without copying it to a data warehouse
• Build generative AI apps based on high-performance, pgvector-compatible search with full access to your AI models

We'll also share best practices for managing and monitoring your AlloyDB Omni databases, and answer your questions live.

presented by Dave Stokes

Learning PostgreSQL and/or SQL can take time and effort. This webinar showcases an option that does not require installation or access to a PG server. Pgexercises.com provides access to a PG server through a web browser, has established exercises, and has an outstanding user interface. It is easy to work through the exercises, and the website provides detailed explanations of the answers if you get stuck. This webinar will complete the first five basic exercises, detailing the steps and adding comments.

This webinar will benefit anyone new to PG. The material is excellent for those learning SQL and leverages an existing website. The minimal cost and ease of production are big bonuses.

Future

The basic exercises would be easy to complete. The other areas could also be covered to create an extensive series. As the basic SQL material is covered, more PG-specific material comes to the forefront.

presented by Rajan Palanivel

In this talk, Rajan Palanivel, VP of Engineering at Baffle Inc (https://baffle.io/), will share how a PL/RUST based extension can be used to protect sensitive data in PostgreSQL. Rajan will lead the discussion on how PL/RUST allows you to deploy data-centric security into a managed cloud service as well as the performance benefits of RUST.

The discussion will begin by looking at why current approaches could put sensitive data at risk or negatively impact business processes. Rajan will then share a simple use case like protecting data in lower security environments, and build up to a more complex case like running complex queries and compute-intensive processes on encrypted data in the cloud with an architectural example of an in-use application of this solution at a large financial services organization.