Sort time - Mailing list pgsql-performance

From pginfo
Subject Sort time
Date
Msg-id 3DD3D2AE.70413B6D@t1.unisoftbg.com
Whole thread Raw
Responses Re: Sort time
List pgsql-performance
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 !

Any idea about the pg tining?

Regards,
Ivan.


pgsql-performance by date:

Previous
From: Neil Conway
Date:
Subject: Re: Docs about buffers and sortmem setting
Next
From: Andrew Sullivan
Date:
Subject: Re: Docs about buffers and sortmem setting