RE: GSOC 2018 Project - A New Sorting Routine

Hey Tomas!

Sorry to bother but it would be great if we can get the test results this week.

Regards,

Kefan

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