>>>>> "tank" == tank zhang <6220104@xxxxxx> writes: tank> smtoc | character varying(50) | | | tank> Sort Key: smtoc What is the output of SHOW lc_collate; One of the most common reasons for slow sorting is that you're sorting a text/varchar field in a locale other than C. The slowdown for using other locales varies according to the data, the locale, and the operating system, but 8-20x slowdowns are very common, 50-100x slowdowns are not unusual, and there have been reports of even worse cases with unusual script combinations. -- Andrew (irc:RhodiumToad)
