Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group