Postgres World Webinar Series 2024 Program

2024-02-07
18:00
Sean Loiselle [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
2024-05-22
13:00
Rajan Palanivel 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
2024-06-12
13:00
Greg Dostatni 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
2024-06-25
18:00
Luigi Nardi 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
2024-06-26
13:00
Randall Rhea 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...
more

13:00 - 14:00 PostgresWorld Zoom Ops
2024-07-10
13:00
Dave Stokes 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
2024-10-02
18:00
Rajan Palanivel [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
2024-12-10
13:00
Jacque Istok Louis Mugnano Antonio Petrole Ed Espino Apache Cloudberry™ (Incubating): The Latest Database for SQL at Scale
An 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