Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem)

Поиск
Список
Период
Сортировка
От Nikita Malakhov
Тема Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem)
Дата
Msg-id CAN-LCVPauPSXSp4H2UZJnOEVoDURKiaH_Yr_cMDvJ19opn=fuw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem)  (Hannu Krosing <hannuk@google.com>)
Список pgsql-hackers
Hi!

On this - 
> Non-FULL vacuum should already work. Only commands like VACUUM FULL
> and CLUSTER which move tuples around should be disabled on TOAST
> tables.

Cool, toast tables are subject to bloating in update-heavy scenarios
and it's a big problem in production systems, it seems there is a promising
way to solve it once and for all!

Have to mention though that we encountered issues in logical replication
when we made toast values updatable.

Also researching direct tids implementation.

Cheers!

--
Regards,
Nikita Malakhov
Postgres Professional
The Russian Postgres Company

В списке pgsql-hackers по дате отправления: