Postgres Pro
Downloads
Home   >   mailing lists

Re: Questions about temporary tables and performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: Questions about temporary tables and performance
Date
Msg-id 25141.1121575493@sss.pgh.pa.us
Whole thread Raw
In response to Questions about temporary tables and performance  (Steven Rosenstein <srosenst@us.ibm.com>)
List pgsql-performance
Tree view 
Steven Rosenstein <srosenst@us.ibm.com> writes:
> Are there any performance issues or considerations associated with using a
> temporary table in this scenario?

It's probably worthwhile to ANALYZE the temp table after it's filled,
before you start joining to it.

            regards, tom lane

pgsql-performance by date:

Previous
From: Steven Rosenstein
Date:
Subject: Questions about temporary tables and performance
Next
From: Christopher Petrilli
Date:
Subject: Impact of checkpoint_segments under continual load conditions