Re: tuplesort memory usage: grow_memtuples

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: tuplesort memory usage: grow_memtuples
Дата
Msg-id CAEYLb_U0BMuFyHF4cJkU8C+_U5Cb3Qm90mC-VbkTjMQwE+DmfA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: tuplesort memory usage: grow_memtuples  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: tuplesort memory usage: grow_memtuples
Список pgsql-hackers
On 14 October 2012 09:19, Simon Riggs <simon@2ndquadrant.com> wrote:
> This is a very useful optimisation, for both the low and the high end.

Well, I'm about ready to mark this one "ready for committer". There is
this outstanding issue in my revision of August 17th, though:

+         /*
+          * XXX: This feels quite brittle; is there a better principled approach,
+          * that does not violate modularity?
+          */
+         newmemtupsize = (int) floor(oldmemtupsize * allowedMem / memNowUsed);
+         state->fin_growth = true;

I suppose that I should just recognise that this *is* nothing more
than a heuristic, and leave it at that.

-- 
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Global Sequences
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Global Sequences