
TOAST
Postgres FM
00:00
Limits and limitations of toast in PostgreSQL
Exploring the size limitations and restrictions of using toast for storing large values in PostgreSQL, including the maximum size per value, the absence of toast before indexing, and the maximum number of toasted values in a table. The benefits of utilizing partitions for larger tables are also discussed, along with a hypothetical scenario involving numerous wide columns with toast values.
Transcript
Play full episode