Hey Tomas!
I am trying to reproduce the results on my machine. Could you please share the script to generate .ods files?
Regards,
Kefan
On 07/18/2018 07:06 AM, Andrey Borodin wrote:
> Hi, Tomas!
>
>> 15 июля 2018 г., в 1:20, Tomas Vondra <tomas.vondra@2ndquadrant.com
>> <mailto:tomas.vondra@2ndquadrant.com>> написал(а):
>>
>> So I doubt it's this, but I've tweaked the scripts to also set this GUC
>> and restarted the tests on both machines. Let's see what that does.
>
> Do you observe any different results?
>
It did change the CREATE INDEX results, depending on the scale. The full
data is available at [1] and [2], attached is a spreadsheet summary from
the Xeon box.
For the largest scale (1M rows) the regressions for CREATE INDEX queries
mostly disappeared. For 10k rows it still affects CREATE INDEX with a
text column, and the 100k case behaves just like before (so significant
regressions for CREATE INDEX).
I don't have time to investigate this further at the moment, but I'm
still of the opinion that there's little to gain by replacing our
current sort algorithm with this.
[1] https://bitbucket.org/tvondra/sort-intro-sort-xeon/src/master/
[2] https://bitbucket.org/tvondra/sort-intro-sort-i5/src/master/
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services