Re: Need help optimizing this query

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