Re: query planning different in plpgsql? - Mailing list pgsql-performance

From Tom Lane
Subject Re: query planning different in plpgsql?
Date
Msg-id 13574.1256580589@sss.pgh.pa.us
Whole thread Raw
In response to Re: query planning different in plpgsql?  (Michal J. Kubski <michal.kubski@cdt.pl>)
Responses Re: query planning different in plpgsql?  (Waldomiro <waldomiro@shx.com.br>)
Re: query planning different in plpgsql?  ("Michal J. Kubski" <michal.kubski@cdt.pl>)
List pgsql-performance
"Michal J. Kubski" <michal.kubski@cdt.pl> writes:
> [ function that creates a bunch of temporary tables and immediately
> joins them ]

It'd probably be a good idea to insert an ANALYZE on the temp tables
after you fill them.  The way you've got this set up, there is no chance
of auto-analyze correcting that oversight for you, so the planner will
be planning the join "blind" without any stats.  Good results would only
come by pure luck.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Full text search - query plan? PG 8.4.1
Next
From: Waldomiro
Date:
Subject: Re: query planning different in plpgsql?