Select Page

Datavail is a Gold Sponsor of PGConf NYC 2022

PGConf NY

Look for Datavail in New York City on September 22-23, as we’re sponsoring PGConf NYC 2022

PGConf NYC is a non–profit, community–run conference series focused on business users, database professionals, and developers of PostgreSQL, the world’s leading open-source database. The conference delivers two days packed with presentations about PostgreSQL and related technologies.

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

Presentation:

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
Not attending the conference or looking to further explore your PostgreSQL needs? Pre-schedule a meeting with one of our experts. Simply fill out the form and we’ll confirm a time that works best for you.

Schedule Your Meeting with a Data Expert:

Check out some of our best PostgreSQL resources prior to the conference.

PostgreSQL Services

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

Event Details

City: New York, NY

Venue: Convene

When: September 22, 2022

Time: 8:00 am ET