| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | Bendik Rognlien Johansen <bendik(dot)johansen(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Slow query with joins |
| Date: | 2006-01-13 23:34:54 |
| Message-ID: | 20060113233454.GM9017@pervasive.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Jan 11, 2006 at 10:30:58PM +0100, Bendik Rognlien Johansen wrote:
> The sort is definitively the culprit. When I removed it the query was
> instant. I tried setting work_mem = 131072 but it did not seem to
> help. I really don't understand this :-( Any other ideas?
What's explain analyze show with the sort in?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-01-14 00:06:40 | Re: Stable function being evaluated more than once in a single query |
| Previous Message | Michael Stone | 2006-01-13 22:48:01 | Re: insert without oids |