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
|
| Список | 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 по дате отправления: