Steven Rosenstein <[EMAIL PROTECTED]> 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
Postgres Version:
7.3.9 and 8.0.1 (different sites use different versions depending on when
they first installed Postgres)
Migration Plans:
All sites on 8.n within the next 6-9 months.
Scenario:
A temporary table is created via a "SELECT blah INTO TEMPORARY TABLE blah
FROM...". The SELECT qu