Hi, On Fri, 23 Oct 2009 16:56:36 +0100, Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx> wrote: > On Fri, Oct 23, 2009 at 4:49 PM, Scott Mead > <scott.lists@xxxxxxxxxxxxxxxx>wrote: > >> >> >> Do you not have an index on last_snapshot.domain_id? >> > > that, and also try rewriting a query as JOIN. There might be difference in > performance/plan. > Thanks, it runs better (average 240s, not 700s) with the index. Rewriting queries as JOINs does not make any difference. The last_snapshot is a temp table created earlier in the procedure and the query in question is preceded with CREATE TEMPORARY TABLE as well, not a cursor. I still do not get why it performs differently inside the procedure. Is there any way to see what planning decisions were made? Best regards, Michal -- I hear and I forget. I see and I believe. I do and I understand. (Confucius) -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
