Sorry for replying to my own post.
I forgot to include my version information, I used:
PostgreSQL 8.1.0 on powerpc-apple-darwin8.3.0, compiled by GCC
powerpc-apple-darwin8-gcc-4.0.0 (GCC) 4.0.0 (Apple Computer, Inc.
PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
4.0.1 20050727 (Red Hat 4.0.1-5)
On both the same result happens.
In response to
pgsql-performance by date
|Next:||From: Gabriele Turchi||Date: 2006-07-18 07:25:40|
|Subject: Re: Big differences in plans between 8.0 and 8.1|
|Previous:||From: Rusty Conover||Date: 2006-07-18 06:42:58|
|Subject: Temporary table retains old contents on update eventually causing slow temp file usage.|