Re: Threaded Sorting

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Bingo! Want to increase sorting performance, give it more I/O
> > bandwidth, and it will take 1/100th of the time to do threading.
>
> > Added to TODO:
> > * Allow sorting to use multiple work directories
>
> Yeah, I like that. Actually it should apply to all temp files not only
> sorting.
>
> A crude hack would be to allow there to be multiple pg_temp_NNN/
> subdirectories (read symlinks) in a database, and then the code would
> automatically switch among these.

TODO updated:

* Allow sorting/temp files to use multiple work directories

Tom, what temp files do we use that aren't for sorting; I forgot.

> Probably a cleaner idea would be to somehow integrate this with
> tablespace management --- if you could mark some tablespaces as intended
> for temp stuff, the system could round-robin among those as it creates
> temp files and/or temp tables.

Yes, tablespaces would be the place for this.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073