| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | pginfo <pginfo(at)t1(dot)unisoftbg(dot)com> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Sort time |
| Date: | 2002-11-14 20:00:01 |
| Message-ID: | Pine.LNX.4.33.0211141259030.1942-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, 14 Nov 2002, pginfo wrote:
> Hi,
>
> Why is the sort part of my query getting so much time?
>
> I run a relative complex query and it gets about 50 sec.
> For sorting I need another 50 sec!
>
> Can I increase the sort memory for better performance?
> How meny memory is needet for the sort in pg.
> The same data readet in java and sorted cost 10 sec !
Increasing sort_mem can help, but often the problem is that your query
isn't optimal. If you'd like to post the explain analyze output of your
query, someone might have a hint on how to increase the efficiency of the
query.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-11-14 20:19:52 | Re: [PERFORM] Upgrade to dual processor machine? |
| Previous Message | scott.marlowe | 2002-11-14 19:58:41 | Re: Upgrade to dual processor machine? |