Page 1 of 2
tsort and psort
Posted: Fri Apr 06, 2012 11:47 am
by qt_ky
This is a bit of a trivia question, and I only know the answer to #2:
1. What does the T stand for in the tsort operator, and how do you know?
2. What does the P stand for in the psort operator?
Posted: Fri Apr 06, 2012 3:10 pm
by nagarjuna
What is a psort ?
Posted: Fri Apr 06, 2012 4:02 pm
by ray.wurlod
A psort is a sort with a silent p, as in swimming.
Posted: Fri Apr 06, 2012 6:02 pm
by chulett
Don't you mean pswimming?
Sorry. Me, I have no idea what either letter stands for... waiting to be educated.
Posted: Fri Apr 06, 2012 7:17 pm
by jwiles
Well, pshah...
p for partition sort
t: (a hint) if you know about the parallel engine's history, this should come pretty easy
Posted: Fri Apr 06, 2012 7:26 pm
by ray.wurlod
Tsort is a place on Terry Pratchett's Discworld.
Posted: Fri Apr 06, 2012 7:46 pm
by jwiles
tsort is also a *nix utility
Posted: Fri Apr 06, 2012 9:22 pm
by qt_ky
Total sort...
Topological sort...
http://en.wikipedia.org/wiki/Torrent_Systems 
http://en.wikipedia.org/wiki/Timsort
Either tsort or psort can be used to sort a partition, so I was wondering how the T and P designators actually came about. The docs confuse the matter further by associating psort with the UNIX sort program. Maybe it should have been called usort; it seems the P is meaningless. Older docs mention psort with the Syncsort utility also.
Posted: Mon Apr 09, 2012 6:52 am
by priyadarshikunal
May be the psort (partition sort) was developed earlier and since it could sort partitioned data it was called psort. Then tsort operator came in which had capability of performing total sort in addition to partition sort and hence it was called tsort.
This is just based on my assumption as in documentaion it is written as "Because of the additional capabilities in tsort, it is recommended that you use this operator rather than psort." Also it uses the sort engine of its own.
Posted: Mon Apr 09, 2012 9:42 pm
by qt_ky
According to the product guides:
psort
Yes, "p" for partition sort.
tsort
And, "t" does not appear to be documented what it stands for. We can speculate until the cows come home... Anyone know if it's documented?
Posted: Wed Apr 10, 2013 12:30 am
by nikhil_bhasin
Hi, can anyone please describe the differences between tsort and psort operators. What i am looking for is exactly what conditions lead to insertion of psort operator and how it works.
Posted: Wed Apr 10, 2013 2:36 am
by BI-RMA
psort will never be inserted by DataStage because tsort is the preferred option for sorting.
No clue to the naming, either. Suggest "true"-sort, as in "the-one-and-only-true-sorting-utility".
Posted: Wed Apr 10, 2013 7:27 am
by chulett
Tony has inferred above that the "t" stands for "Torrent".
Posted: Wed Apr 10, 2013 7:54 am
by BI-RMA
Is Tony the guy who calls himself Eric?
And did you say "Torrent" or "Torment"???
Posted: Wed Apr 10, 2013 8:08 am
by chulett
James, Eric, Tony...
somebody inferred it up there somewhere.