Re: [HACKERS] sort on huge table - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] sort on huge table
Date
Msg-id 19827.940199380@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] sort on huge table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] sort on huge table
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] don't know whether nodes of type 719 are equal
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] pg_type questions