Re: massive update on gin index

Поиск
Список
Период
Сортировка
От Marcos Pegoraro
Тема Re: massive update on gin index
Дата
Msg-id CAB-JLwZeSdiRJkGMFEzpdkN97XbRbYr5G2ntAGzYmAjtRjihog@mail.gmail.com
обсуждение исходный текст
Ответ на Re: massive update on gin index  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
Em qua., 14 de set. de 2022 às 16:55, Tom Lane <tgl@sss.pgh.pa.us> escreveu:
GIN does have a "pending list" of insertions not yet pushed into the main
index structure, and search performance will suffer if that gets too
bloated.  I don't recall much about how to control that, but I think
vacuuming the table will serve to empty the pending list.  Also see

https://www.postgresql.org/docs/current/gin-implementation.html#GIN-FAST-UPDATE

                        regards, tom lane

Correct, if I want use that index immediately with same performance I have to call

select pg_catalog.gin_clean_pending_list('idxphones');

Or wait next autovacuum.

thanks
Marcos

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: massive update on gin index
Следующее
От: Mladen Gogala
Дата:
Сообщение: Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?