Re: [PERFORM] Questions about temporary tables and performance

2005-07-16 Thread Tom Lane
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

[PERFORM] Questions about temporary tables and performance

2005-07-16 Thread Steven Rosenstein
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