Re: Temporary table retains old contents on update eventually causing slow temp file usage.

From: Rusty Conover <rconover(at)infogears(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Temporary table retains old contents on update eventually causing slow temp file usage.
Date: 2006-07-18 06:56:13
Message-ID: 3D8B4645-34C7-4AAB-95C4-F41557DE6389@infogears.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gabriele Turchi 2006-07-18 07:25:40 Re: Big differences in plans between 8.0 and 8.1
Previous Message Rusty Conover 2006-07-18 06:42:58 Temporary table retains old contents on update eventually causing slow temp file usage.