Postgres World Webinar Series 2024 Program
presented by Sean Loiselle
video
PostgreSQL's materialized views are a great tool to provide low-latency answers to complex queries – but did you know they could offer serializable consistency if you used cutting-edge streaming engines, many millions of dollars, and countless hours of work from talented systems engineers and academics? Oh, and I guess you could then also join them with arbitrarily complex queries over Kafka to...
more 18:00 - 19:00 PostgresWorld Zoompresented by Rajan Palanivel
video
The popularity of PostgreSQL makes it the prime candidate to be the database for a multi-tenant SaaS. But with multi-tenancy there are two fundamental issues: How do you make sure that the tenant has control over their data in a third party SaaS environment? How do you make sure that the tenant’s data is isolated from each other so that a tenant’s data doesn’t get exposed to other tenants? ...
more 13:00 - 14:00 PostgresWorld Zoom Opspresented by Greg Dostatni
video
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...
more 13:00 - 14:00 PostgresWorld Zoom Opspresented by Luigi Nardi
video
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...
more 18:00 - 19:30 PostgresWorld Zoom Opspresented by Randall Rhea
video
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 l...
presented by Dave Stokes
video
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...
more 13:00 - 14:00 PostgresWorld Zoom Fundamentalspresented 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 ...
more 18:00 - 19:30 PostgresWorld Zoom OpsAn Incubating Advanced Analytics engine built with decades of R&D in PostgreSQL / Greenplum Database
presented by Jacque Istok, Louis Mugnano, Antonio Petrole, and Ed Espino
Unlock new possibilities in data analytics with Apache Cloudberry, a powerful open-source platform designed for at-scale data exploration. This webinar is tailored for existing PostgreSQL users and PostgreSQL variants such as Greenplum Database, RedShift, etc to enhance analytical capabilities.
Join us to discover how Apache Cloudberry bridges the gap between structured and semi-structured d...
more 13:00 - 14:00 PostgresWorld Zoom