Comments on: Unlocking the Secrets of TOAST: How To Optimize Large Column Storage in PostgreSQL for Top Performance and Scalability https://www.percona.com/blog/unlocking-the-secrets-of-toast-how-to-optimize-large-column-storage-in-postgresql-for-top-performance-and-scalability/ Thu, 14 Dec 2023 01:27:34 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Tobias https://www.percona.com/blog/unlocking-the-secrets-of-toast-how-to-optimize-large-column-storage-in-postgresql-for-top-performance-and-scalability/#comment-10974086 Fri, 09 Jun 2023 08:06:19 +0000 https://www.percona.com/blog/?p=84716#comment-10974086 yes contradiction, thought the same.

]]> By: Gurmokh https://www.percona.com/blog/unlocking-the-secrets-of-toast-how-to-optimize-large-column-storage-in-postgresql-for-top-performance-and-scalability/#comment-10974049 Fri, 14 Apr 2023 14:04:21 +0000 https://www.percona.com/blog/?p=84716#comment-10974049 Contradiction in the article.
Extended strategy it states:

This is the default strategy for most TOAST-able data types, such as text or bytea.

But then in the pitfalls of TOAST you state.

You can’t use a TOAST table for data types such as text or varchar,

]]> By: Richard O'Riordan https://www.percona.com/blog/unlocking-the-secrets-of-toast-how-to-optimize-large-column-storage-in-postgresql-for-top-performance-and-scalability/#comment-10973906 Wed, 01 Feb 2023 17:33:06 +0000 https://www.percona.com/blog/?p=84716#comment-10973906 Hi there, very good article, just one question, you have the following line “You can’t use a TOAST table for data types such as text or varchar, which can also be large.” my understanding is that columns of type varchar and text will get toasted if over 2kb. Are you saying that these data types do not get stored in a TOAST table?
Thanks.

]]>