Presented by:

Perrenwalkerheadshot

Perren Walker

Tessell

Perren Walker currently works at Tessell on their customer & product innovation team. Prior to Tessell, Perren worked in various product management and operational roles at Oracle. These responsibilities included Enterprise Java Cloud Native Portfolio, Identity and Access Management, Service Oriented Architecture Management, BI, and Service Level Management products. In addition to bringing the Configuration and Compliance Cloud Service to general availability, Perren also drove product portfolios from a business development and market competitive intelligence standpoint, with P&L and portfolio revenue in excess of +500m.

In his free time, Perren volunteers for Bay Area nonprofits, focusing on understanding, articulating and aligning operational and impact metrics with the organization's mission. Living and working in San Francisco, Perren can be found with his Spouse and twins exploring Northern California.

No video of the event yet, sorry!
Download the Slides

Dive into PostgreSQL I/O !

In this talk, we will survey PostgreSQL database systems I/O patterns. In PostgreSQL, we do have I/O patterns like *Checkpoint *Background Writer *Vacuum/Autovacuum *Client Backend *Bulk Read/Writes *WAL I/O *Query I/O *Query Parallel Reads *Index I/O

Also, we'll dive deep into PostgreSQL catalog tables, which actually talks about I/O. With these numbers, we can tune and appropriately size the underlying database hardware resources CPU, Memory & input/output operations per second (IOPS).

Date:
2024 April 19 15:00 PDT
Duration:
20 min
Room:
Winchester
Conference:
Postgres Conference 2024
Language:
English
Track:
Ops
Difficulty:
Advanced