>>>>> "Robert" == Robert Haas <robertmh...@gmail.com> writes:
Robert> All right, it seems Tom is with you on that point, so after Robert> some study, I've committed this with very minor modifications. While hacking up a patch to demonstrate the simplicity of extending this to the Datum sorter, I seem to have run into a fairly major issue with this: there seems to be no attempt whatsoever to handle spilling to disk correctly. The data spilled to disk only has the un-abbreviated values, but nothing tries to re-abbreviate it (or disable abbreviations) when it is read back in, and chaos ensues: set work_mem = 64; select v, v > lag(v) over (order by v) from (select 'B'||i as v from generate_series(1,10000) i union all select 'a'||i from generate_series(1,10000) i offset 0) s order by v limit 20; v | ?column? --------+---------- a10000 | B10000 | f a1000 | t a1001 | t a1002 | t a1003 | t B1000 | f B1001 | t B1002 | t B1003 | t B1004 | t B1005 | t a1004 | t a1005 | t a1006 | t a1007 | t a1008 | t B1 | f B10 | t B100 | t (20 rows) -- Andrew (irc:RhodiumToad) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers