Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached

[Alexander Farber]

Thank you all, I will try at first

shared_buffers = 16GB        and

index on words_scores(uid, length(word) desc)