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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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