On 13 Nov 2002 at 14:30, Björn Metzdorf wrote:
> Could you elaborate on what exactly is a query requiring sorting (and
> therefore is affected by sort_mem setting)?
> Is it a SELECT with WHERE-clause using seq scan? Is it rebuilding of an
> index? What else could it be?
I can think of an sql query with an order by clause on a non-indexed field and
say that field is not included in where condition e.g.
select name, addreess from users where id>1000 order by name;
with index on id.
Bye
Shridhar
--
You canna change the laws of physics, Captain; I've got to have thirty minutes!