Postgres World Webinar Series 2024 Program
[Meetup Livestream] Better materialized views in 1 million LOC: Inside Materialize's PostgresSQL src
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 Zoom
Using Postgres in a Multi-Tenant SaaS - Securing Everyone’s Data
presented 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 Ops
Advanced Strategies for PostgreSQL Lock Management
presented 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 Ops
NYC Postgres Meetup Livestream: Postgres Automation and Hyperscaling
presented 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 Ops
Build Gen AI Apps on PostgreSQL that Run Anywhere
presented 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...
Learning PostgreSQL
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 Fundamentals
[Meetup Livestream] Leveraging a PL/RUST extension to protect sensitive data in PostgreSQL
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 ...
more 18:00 - 19:30 PostgresWorld Zoom Ops