Datavail is a Gold Sponsor of PGConf NYC 2022
Look for Datavail in New York City on September 22-23, as we’re sponsoring PGConf NYC 2022
Join us at the Convene 237 Park Avenue in NYC! We’ll be there with Postgres experts on hand, showcasing our database expertise.
Receive 15% off registration with our exclusive discount code: DATAVAIL2022
Tale of the PostgreSQL TOAST Tables
Shailesh Rangani, Practice Lead for PostgreSQL
PostgreSQL’s default page size is 8 KB, and it does not allow row/tuple to span multiple pages. TOAST (The Oversized-Attribute Storage Technique) is a mechanism PostgreSQL uses to keep tuple from exceeding the size of a default page size, so the block size is a hard upper limit on row size. To allow user tables to have rows wider than this, the TOAST mechanism breaks up wide field values into smaller pieces, which are stored “out of line” in a TOAST table associated with the user table.
In this presentation, we will show various aspects of the TOAST tables, the storage options for storing TOAST tables, and the impact on the performance on text size of the column. We also cover how to query information related to TOAST tables from PostgreSQL metadata.
In this session, Shailesh will cover:
- Introduction to TOAST table mechanism
- TOAST table storage strategy options
- Optimizing query time with the TOAST table storage strategy
- How to find information about TOAST tables using PostgreSQL metadata
- Impact of Texts Size on PostgreSQL Performance
Schedule Your Meeting with a Data Expert:
Check out some of our best PostgreSQL resources prior to the conference.
Migrating and Modernizing Oracle Workloads on AWS
Why & How to Migrate from Oracle to PostgreSQL
Why Your PostgreSQL Databases Should Live on Amazon Aurora
Datavail’s TechBoost Modernization Journey from SQL Server to Amazon Aurora PostgreSQL
3 Reasons to Make the Move to PostgreSQL
City: New York, NY
When: September 22, 2022
Time: 8:00 am ET