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

From: Vaibhav Kaushal <vaibhavkaushal123(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: How would sorting work with millions of rows in a huge DB with PG?
Date: 2011-04-09 23:50:02
Message-ID: 1302393002.2369.3.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 the results in such conditions.

A pointer to some doc page or code would be great for me.

Regards,
Vaibhav

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2011-04-10 00:08:59 Re: Bug in pg_hba.conf or pg_basebackup concerning replication connections
Previous Message Noah Misch 2011-04-09 23:44:13 Re: pg_upgrade bug found!