Vectorize pg_visibility.pg_visibility_map_summary

Поиск
Список
Период
Сортировка
От Matthias van de Meent
Тема Vectorize pg_visibility.pg_visibility_map_summary
Дата
Msg-id CAEze2WgPu-EYYuYQimy=AHQHGa7w8EvLVve5DM5eGMR6zh-7sw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Vectorize pg_visibility.pg_visibility_map_summary
Список pgsql-hackers
Hi,

Whilst working on fixing a bug in GiST and SP-GiST's index-only scan
systems, I noticed that pg_visibility is sometimes rather wasteful
with the APIs which it calls into; especially now that there are more
optimized APIs available.

Here's one small patch that makes it use the visibilitymap_count() API
for pg_visibility_map_summary(), replacing its own bespoke counting
mechanism with the primary implementation that has vectorized
optimizations, thus reducing the overhead of
pg_visibility_map_summary.

CC-ed to authors of 41c51f0c68, visibilitymap_count was optimized, and
this potential user wasn't notified of that.


Kind regards,

Matthias van de Meent
Databricks (https://www.databricks.com)

Вложения

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