Sort time

From: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Sort time
Date: 2002-11-14 16:43:26
Message-ID: 3DD3D2AE.70413B6D@t1.unisoftbg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Manfred Koizar 2002-11-14 17:15:45 Re: Upgrade to dual processor machine?
Previous Message Wei Weng 2002-11-14 16:07:00 Re: swapping?