Re: Skip partition tuple routing with constant partition key

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Skip partition tuple routing with constant partition key
Дата
Msg-id CAM-w4HO3+v2Jtxc5P4eWB5DW9m4vyfUJb8eR9c8Akcf3SSMJgQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Skip partition tuple routing with constant partition key  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: Skip partition tuple routing with constant partition key  (Amit Langote <amitlangote09@gmail.com>)
Список pgsql-hackers
There are a whole lot of different patches in this thread.

However this last one https://commitfest.postgresql.org/37/3270/
created by Amit seems like a fairly straightforward optimization that
can be evaluated on its own separately from the others and seems quite
mature. I'm actually inclined to set it to "Ready for Committer".

Incidentally a quick read-through of the patch myself and the only
question I have is how the parameters of the adaptive algorithm were
chosen. They seem ludicrously conservative to me and a bit of simple
arguments about how expensive an extra check is versus the time saved
in the boolean search should be easy enough to come up with to justify
whatever values make sense.



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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: do only critical work during single-user vacuum?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Estimating HugePages Requirements?