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

Re: Strange issue with vacuum and temp tables

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Strange issue with vacuum and temp tables
Date: 2008-03-29 00:25:53
Message-ID: 20080329002553.GA20303@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-admin
Jeff Frost wrote:

> A look at the code revealed that the temp tables were created via normal  
> methods, so I'm curious to know if there is a bug regarding temp tables 
> not going away on Postgresql-8.2.x after the connection is closed?

Well, a process crash could leave temp tables behind which causes the
problem.  Otherwise I think they should go away normally ...

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2008-03-29 00:26:46
Subject: Re: Strange issue with vacuum and temp tables
Previous:From: Jeff FrostDate: 2008-03-29 00:09:42
Subject: Strange issue with vacuum and temp tables

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