Re: An "obvious" index not being used - Mailing list pgsql-performance

>>> Daniele Varrazzo <piro@develer.com> 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