Re: [HACKERS] How would sorting work with millions of rows in a huge DB with PG?

2011-04-10 Thread Vaibhav Kaushal
Thanks a lot for the help. Regards, Vaibhav On Sun, Apr 10, 2011 at 11:07 AM, wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Sun, Apr 10, 2011 at 05:20:02AM +0530, Vaibhav Kaushal wrote: > > Hello all, > > > > I was going through some papers related to sorting and since I am >

Re: [HACKERS] How would sorting work with millions of rows in a huge DB with PG?

2011-04-09 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, Apr 10, 2011 at 05:20:02AM +0530, Vaibhav Kaushal wrote: > Hello all, > > I was going through some papers related to sorting and since I am > studying PG code side by side, I wondered how sorting would be done on a > DB with millions of rows o

[HACKERS] How would sorting work with millions of rows in a huge DB with PG?

2011-04-09 Thread Vaibhav Kaushal
Hello all, I was going through some papers related to sorting and since I am studying PG code side by side, I wondered how sorting would be done on a DB with millions of rows on disk with GBs of data. Since holding everything in memory would not be the possible solution, how do we actually sort th