On 07/24/2018 12:21 AM, Kefan Yang wrote:
Hi Tomas!
I did a few tests on my own Linux machine, but the problem is that my
resources on AWS(CPU, RAM and even Disk space) are very limited. I
considered establishing virtual machine on my own PC but the performance
is even worse.
My original patch has two main optimizations: (1) switch to heap sort
when depth limit exceeded (2) check whether the array is presorted only
once at the beginning. Now I want to test these optimizations
separately. On AWS EC2 instance, regressions on CREATE INDEX cases seems
to be less significant if we use (1) only, but I can only test up to
100000 records and 512MB memory using your scripts.
So would you mind re-running the tests using the two patches I provided
in the attachment? That will be very helpful
I can do that, but it'll have to wait a couple of days. I'm currently
using the boxes for some other tests.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
