The Surprising Impact of Medium-Size Texts on PostgreSQL Performance

*Find the article on our blog here:*

https://pganalyze.com/blog/5mins-postgres-TOAST-performance

Today, we're going to talk about the surprising impact of medium sized texts on Postgres performance. We take a look at a great blog post by Haki Benita.

*Learn more about pganalyze:*

https://pganalyze.com

https://pganalyze.com/newsletter

https://twitter.com/pganalyze/

*Check out the pganalyze library for eBooks, webinars, and more:*

https://pganalyze.com/resources

📑 *What we have discussed in this episode of 5mins of Postgres:*

*The Surprising Impact of Medium-Size Texts on PostgreSQL Performance - by Haki Benita*

https://hakibenita.com/sql-medium-text-performance

*Haki Benita on Twitter/X*

https://twitter.com/be_haki

*Out-of-Line, On-Disk TOAST Storage - postgresql.org docs*

https://www.postgresql.org/docs/current/storage-toast.html#STORAGE-TOAST-ONDISK

*5mins of Postgres E3: Postgres performance cliffs with large JSONB values and TOAST*

https://pganalyze.com/blog/5mins-postgres-jsonb-toast