On Thu, Oct 29, 2009 at 10:10 AM, Anj Adu <fotographs@gmail.com> wrote:
> Join did not help. A sequential scan is still being done. The
> hardcoded value in the IN clause performs the best. The time
> difference is more than an order of magnitude.
If you want help debugging a performance problem, you need to post
your EXPLAIN ANALYZE results.
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
...Robert