On Aug 16, 2007, at 7:01 PM, Tom Lane wrote:
…
Why is the sort step so slow? Sorting a mere 13k rows shouldn't take
very long. Maybe you are overrunning work_mem and it's falling back
to a disk sort ... what is work_mem set to?
By default work_mem is set to "1024". Increasing the value to "8192"
halves the execution time, still leaving a factor twenty-five
performance decrease compared to using the index. The machine I'm
testing this on is a very modest Pentium 3 at 450 MHz.
Another theory is that you are using a locale in which strcoll() is
horridly expensive :-(
Running 'locale' indicates I'm using "en_US.UTF-8" with language
"en_NL:en". My databases all use the UTF8 encoding.
Sincerely,
Frank
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
