Postgres Pro
Downloads
Home   >   mailing lists

Re: Temporary table retains old contents on update eventually causing slow temp file usage. - Mailing list pgsql-performance

From Rusty Conover
Subject Re: Temporary table retains old contents on update eventually causing slow temp file usage.
Date
Msg-id 3D8B4645-34C7-4AAB-95C4-F41557DE6389@infogears.com
Whole thread Raw
List pgsql-performance
Tree view 
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.
build 5026)

and

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.

Cheers,

Rusty
--
Rusty Conover
InfoGears Inc.
http://www.infogears.com

pgsql-performance by date:

Previous
From: Gabriele Turchi
Date:
Subject: Re: Big differences in plans between 8.0 and 8.1
Next
From: Rusty Conover
Date:
Subject: Temporary table retains old contents on update eventually causing slow temp file usage.