database sorting algorithms.

From: Jian He <hejian(dot)mark(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: database sorting algorithms.
Date: 2021-05-01 07:06:49
Message-ID: CAMV54g0QLUWEXdrCbywoB3C-UGhLMBqL49xAKMk6j1w7cmXCXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Been self study Database, from database I deep dived into sorting
algorithms.

Databases can do in-memory QuickSort. It also has an on-disk MergeSort.

For MergeSort: I follow this tutorial https://youtu.be/6pV2IF0fgKY?t=1108
(around 1 minutes only)

But I am still not fully understanding about *nlogn*. I understand how many
passes it will take, that is* logn. *
Yes each pass will sort N elements.
But I still don't get the *N* stand f*or in n*logn.*
Why does each pass take
*n time to sort it? *

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2021-05-01 09:15:17 Re: database sorting algorithms.
Previous Message Mike Beachy 2021-04-30 20:53:52 Re: -1/0 virtualtransaction