>>> Daniele Varrazzo <[EMAIL PROTECTED]> wrote:
> select count(*) from foo
> where foo.account_id in (
> select id from accounts where system = 'abc');
> Total runtime: 13412.226 ms
Out of curiosity, how does it do with the logically equivalent?:
select count(*) from foo
where exists (select * from accounts
where accounts.id = foo.account_id
and accounts.system = 'abc');
-Kevin
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
