On Thu, Apr 22, 2010 at 8:14 AM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote: > This will use an index on bar.bar_id if it exists. Obviously, any > indexes on foo are not used after creating the array but doesn't > matter much as long as the right side is indexed. Your cursor method > does do any better in this regard. You can create an index on a temp er, meant to say: 'doesn't do any better'. merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
