Re: Patch: ResourceOwner optimization for tables with many partitions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Patch: ResourceOwner optimization for tables with many partitions
Дата
Msg-id 15225.1453839844@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Patch: ResourceOwner optimization for tables with many partitions  (Aleksander Alekseev <a.alekseev@postgrespro.ru>)
Ответы Re: Patch: ResourceOwner optimization for tables with many partitions
Список pgsql-hackers
Aleksander Alekseev <a.alekseev@postgrespro.ru> writes:
>> Um, that's not too surprising, because they're exactly the same patch?

> Wrong diff. Here is correct one. 

This still had quite a few bugs, but I fixed them (hope I caught
everything) and pushed it.

I did some performance testing of the ResourceArray code in isolation.
It appears that you need 100 or so elements before the hash code path
is competitive with the array path, so I increased the cutover point
quite a bit from what you had.
        regards, tom lane



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