On Wed, May 9, 2012 at 2:11 AM, Robert Klemme
<shortcutter@googlemail.com> wrote:
> On Fri, May 4, 2012 at 3:04 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
>
>> let's see the query plan...when you turned it off, did it go faster?
>> put your suspicious plans here: http://explain.depesz.com/
>
> I suggest to post three plans:
>
> 1. insert into temp table
> 2. access to temp table before analyze
> 3. access to temp table after analyze
>
> Maybe getting rid of the temp table (e.g. using a view or even an
> inline view) is even better than optimizing temp table access.
yeah -- perhaps a CTE might work as well.
merlin
