On Thu, Oct 29, 2009 at 10:10 AM, Anj Adu <fotographs@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
