Re: Upgrade to dual processor machine?

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!