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.