Re: slow query if add order by

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Paolo Tavalazzi <ptavalazzi(at)charta(dot)it>
Subject: Re: slow query if add order by
Date: 2004-05-14 19:53:07
Message-ID: 40A523A3.4050704@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Paolo Tavalazzi wrote:

>
> I have 2 query that differ only for order by clause.
> The time of execution of the two query is a lot of different.

How much sort_mem are you using ?

Regards
Gaetano Mendola

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Glenn Sullivan 2004-05-14 20:19:20 Re: Column names and datatypes
Previous Message Mike Mascari 2004-05-14 19:47:31 Re: Column names and datatypes