Re: [HACKERS] sort on huge table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] sort on huge table
Date: 1999-10-17 22:29:40
Message-ID: 19827.940199380@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

OK, I have now finished up my psort reconstruction project. Sort nodes
and btree CREATE INDEX now use the same sorting module, which is better
than either one was to start with.

This resolves the following TODO items:

* Make index creation use psort code, because it is now faster(Vadim)
* Allow creation of sort temp tables > 1 Gig

Also, sorting will now notice if it runs out of disk space, which it
frequently would not before :-(. Both memory and disk space are used
more sparingly than before, as well.

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mike Mascari 1999-10-17 23:00:12 Re: [HACKERS] Re: ORACLE COMMENT statement
Previous Message Tom Lane 1999-10-17 21:47:11 Re: [HACKERS] don't know whether nodes of type 719 are equal