Postgres Pro
Downloads
Home   >   mailing lists

Re: slow query if add order by - Mailing list pgsql-general

From Gaetano Mendola
Subject Re: slow query if add order by
Date
Msg-id 40A523A3.4050704@bigfoot.com
Whole thread Raw
In response to slow query if add order by  (Paolo Tavalazzi <ptavalazzi@charta.it>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: Column names and datatypes
Next
From: Glenn Sullivan
Date:
Subject: Re: Column names and datatypes