On Mon, Oct 26, 2009 at 6:05 AM, Michal J. Kubski <michal.kubski@xxxxxx> wrote: > 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? not directly....can we see the function? merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
