Did anybody think about threaded sorting so far?
Assume an SMP machine. In the case of building an index or in the case 
of sorting a lot of data there is just one backend working. Therefore 
just one CPU is used.
What about starting a thread for every temporary file being created? 
This way CREATE INDEX could use many CPUs.
Maybe this is worth thinking about because it will speed up huge 
databases and enterprise level computing.

    Best regards,

        Hans-Jürgen Schönig

*Cybertec Geschwinde u Schoenig*
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/1/913 68 09; +43/664/233 90 75
www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at 
<http://cluster.postgresql.at>, www.cybertec.at 
<http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at>

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to