Re: [HACKERS] trying to study how sorting works

2015-03-26 Thread Ashutosh Bapat
On Thu, Mar 26, 2015 at 10:44 PM, hitesh ramani hiteshram...@hotmail.com wrote: Hello devs, I'm trying to understand how sorting exactly works in Postgres, I've understood that there are two sorting mechanisms depending on the size of the data, one being qsort which is initiated if workmem

[HACKERS] trying to study how sorting works

2015-03-26 Thread hitesh ramani
Hello devs, I'm trying to understand how sorting exactly works in Postgres, I've understood that there are two sorting mechanisms depending on the size of the data, one being qsort which is initiated if workmem is 1024 kb and the other being external sort which is initiated in the other case.

Re: [HACKERS] trying to study how sorting works

2015-03-26 Thread Jim Nasby
On 3/26/15 12:14 PM, hitesh ramani wrote: Hello devs, I'm trying to understand how sorting exactly works in Postgres, I've understood that there are two sorting mechanisms depending on the size of the data, one being qsort which is initiated if workmem is 1024 kb That's incorrect. What