Re: [HACKERS] Small improvement to compactify_tuples

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Small improvement to compactify_tuples
Дата
Msg-id 19570.1510155199@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Small improvement to compactify_tuples  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: [HACKERS] Small improvement to compactify_tuples
Re: [HACKERS] Small improvement to compactify_tuples
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Tue, Nov 7, 2017 at 4:39 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> What I'm getting from the standard pgbench measurements, on both machines,
>> is that this patch might be a couple percent slower than HEAD, but that is
>> barely above the noise floor so I'm not too sure about it.

> Hmm.  It seems like slowing down single client performance by a couple
> of percent is something that we really don't want to do.

I do not think there is any change here that can be proven to always be a
win.  Certainly the original patch, which proposes to replace an O(n log n)
sort algorithm with an O(n^2) one, should not be thought to be that.
The question to focus on is what's the average case, and I'm not sure how
to decide what the average case is.  But more than two test scenarios
would be a good start.
        regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Horrible CREATE DATABASE Performance in High Sierra
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Horrible CREATE DATABASE Performance in High Sierra