| From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
|---|---|
| To: | "Pat Maddox" <pergesu(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Need help optimizing this query |
| Date: | 2007-07-18 23:30:48 |
| Message-ID: | 01361ACA-2035-4E79-9956-5182F87D2A78@seespotcode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brijesh Shrivastav | 2007-07-19 00:01:10 | Can someone shed some light on following error: "pg_tblspc/16763/16764/PG_VERSION" is missing |
| Previous Message | Francisco Reyes | 2007-07-18 22:48:12 | Re: Feature request: Per database search_path |