Hans-Jürgen Schönig wrote: > Threads are bad - I know ... > I like the idea of a pool of processes instead of threads - from my > point of view this would be useful. > > I am planning to run some tests (GEQO, AIX, sorts) as soon as I have > time to do so (still too much work ahead before :( ...). > If I had time I'd love to do something for the PostgreSQL community :(. > > As far as sorting is concerned: It would be fine if it was possible to > define an alternative location for temporary sort files using SET. > If you had multiple disks this would help in the case of concurrent > sorts because this way people could insert and index many tables at once > without having to access just one storage system. > This would be an easy way out of the IO limitation ... - at least for > some problems.
Bingo! Want to increase sorting performance, give it more I/O bandwidth, and it will take 1/100th of the time to do threading. Ingres had a nice feature where you could specify sort directories and it would cycle through those directories while it did the tape sort. Added to TODO: * Allow sorting to use multiple work directories -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html