Re: Optimize external TOAST storage

Поиск
Список
Период
Сортировка
От davinder singh
Тема Re: Optimize external TOAST storage
Дата
Msg-id CAHzhFSEDYc5z-Scf7c7Oo2WYahsz_UFZKGVDq4G2s6a877UFWw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Optimize external TOAST storage  (Dilip Kumar <dilipbalaut@gmail.com>)
Ответы Re: Optimize external TOAST storage  (Dilip Kumar <dilipbalaut@gmail.com>)
Список pgsql-hackers
Thanks Dilip, I have fixed your comments, please find the updated patch.

On Tue, Mar 8, 2022 at 9:44 PM Dilip Kumar <dilipbalaut@gmail.com> wrote:.
+            /* incompressible, ignore on subsequent compression passes. */
+            orig_attr->tai_colflags |= TOASTCOL_INCOMPRESSIBLE;

Do we need to set TOASTCOL_INCOMPRESSIBLE while trying to externalize
it, the comment say "ignore on subsequent compression passes"
but after this will there be more compression passes?  If we need to
set this TOASTCOL_INCOMPRESSIBLE then comment should explain this.
That was a mistake, this flag is not required at this point, as the attribute is externalized it will be marked as TOASTCOL_IGNORE, and such columns are not considered for compression, I removed it. Thanks for pointing it out.

--
Regards,
Davinder
Вложения

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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: pg_walinspect - a new extension to get raw WAL data and WAL stats
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*)