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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
