On Jul 18, 2007, at 17:34 , Pat Maddox wrote:
-> Sort (cost=803054.95..809363.98 rows=2523610
width=64) (actual time=67076.407..75441.274 rows=5799447 loops=1)
Sort Key: videos.id, videos.title, videos.guid
If I'm reading this right, it looks like a majority of the time (about two-thirds) is spent in this sort step. This is a naive guess, but perhaps you may want to increase your work_mem. What's your current work_mem setting?
Michael Glaesemann grzm seespotcode net
