Extend Table AM routine to get total blocks can be analyzed

Поиск
Список
Период
Сортировка
От Pengzhou Tang
Тема Extend Table AM routine to get total blocks can be analyzed
Дата
Msg-id CAG4reARd9z9FAca_dPGQHbHTDCd4SfQnGQCpp7TEXBGVjd7U6Q@mail.gmail.com
обсуждение исходный текст
Список pgsql-hackers
Hi Hackers,

Table AM routine already provided two custom functions to fetch sample blocks and sample tuples,
however, the total blocks the ANALYZE can scan are still restricted to the number of physical blocks
in a table, this doesn't work well for storages which organize blocks in different ways than the heap.

Here is proposing to add a new method named scan_analyze_total_blocks() to provide more flexibility,
it can return physical or logical blocks number which depends on how the table AM implement
scan_analyze_next_block() and scan_analyze_next_tuple().
Вложения

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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: adding partitioned tables to publications
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: dropdb --force