Re: Modifying TOAST policy will not affect the way existing data is stored ?

2021-10-29 Thread Marcos Pegoraro
Em qua., 27 de out. de 2021 às 16:48, Marcos Pegoraro escreveu: > Postgres weekly came today with this interesting article: > https://hakibenita.com/sql-medium-text-performance > > The problem it explains is when you have no one records being stored on > toast, even if they are toastable. That is

Modifying TOAST policy will not affect the way existing data is stored ?

2021-10-27 Thread Marcos Pegoraro
Postgres weekly came today with this interesting article: https://hakibenita.com/sql-medium-text-performance The problem it explains is when you have no one records being stored on toast, even if they are toastable. That is because the size of that column fits on toast_tuple_target size, so it doe