Hans-Jürgen Schönig <postgres@cybertec.at> writes:
> Recently I have come across a simple issue which made me think about it.
> When we create a tmp table (SELECT INTO, CREATE TABLE AS) the planner
> won't know anything about its content after creating it.
Run ANALYZE on the temp table, if you intend to use it enough to justify
gathering stats about it. VACUUM is more work than needed.
regards, tom lane