Re: problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7

Thanks Brandon---that's a very good idea. I'd still like to know why my x86
box can handle the less effecient query better than an E-450, but this is
what I'll do until I can get my curiosity satisfied. ;)

Heather

----- Original Message -----
From: "bpalmer" <bpalmer(at)crimelabs(dot)net>
To: "Heather Johnson" <hjohnson(at)nypost(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Sent: Monday, December 10, 2001 5:34 PM
Subject: Re: [ADMIN] problems doing sub-selects on PostgreSQL 7.1.3 and
Solaris 7

> > SELECT count(*) FROM users WHERE id NOT IN ( SELECT users_id FROM
users_demographics );
>
> I'm not sure about the difference in speed, but try the following for a
> much faster query:
>
> SELECT count(id)
> FROM users
>
> EXCEPT
>
> SELECT users_id
> FROM users_demographics
>
> Should be a great deal faster.
>
> - Brandon
>
>
>
> --------------------------------------------------------------------------
--
> c: 646-456-5455 h:
201-798-4983
> b. palmer, bpalmer(at)crimelabs(dot)net
pgp:crimelabs.net/bpalmer.pgp5
>