On Wed, Jun 26, 2013 at 2:29 AM, Ben <midfi...@gmail.com> wrote: > shouldn't an index scan definitely be fastest here? you don't need to touch > the whole table or index. maybe there something i have misconfigured here? >
How about you try increasing work_mem ? I think a hash join may be the best plan here, and it won't get chosen with low work_mem . Regards Marcin Mańk -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
