HashAgg's batching counter starts at 0, but Hash's starts at 1.

Поиск
Список
Период
Сортировка
От David Rowley
Тема HashAgg's batching counter starts at 0, but Hash's starts at 1.
Дата
Msg-id CAApHDvrshRnA6C0VFnu7Fb9TVvgGo80PUMm5+2DiaS1gEkPvtw@mail.gmail.com
обсуждение исходный текст
Ответы Re: HashAgg's batching counter starts at 0, but Hash's starts at 1.
Список pgsql-hackers
Hi,

While working on 40efbf870 I noticed that when performing a Hash Join
that we always start out by setting nbatch to 1.  That seems
reasonable as it's hard to imagine being able to complete any non-zero
amount of work in fewer than 1 batch.

In the HashAgg case, since 40efbf870, we'll display:

"HashAgg Batches": 0,

if you do something like: explain(analyze, format json) select
distinct oid from pg_class;

I'd rather this said that the number of batches was 1.

Does anyone have any objections to that being changed?

David



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

Предыдущее
От: michael@paquier.xyz
Дата:
Сообщение: Re: [PATCH] Better cleanup in TLS tests for -13beta2
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: max_slot_wal_keep_size and wal_keep_segments