Re: Kill -9 Postmaster and Temporary Tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Schuchardt <daniel_schuchardt(at)web(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Kill -9 Postmaster and Temporary Tables
Date: 2003-09-09 20:55:01
Message-ID: 11781.1063140901@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Daniel Schuchardt <daniel_schuchardt(at)web(dot)de> writes:
> I'v noticed if you kill -9 the Postmaster Temporary Tables (Shemas) will stay in the DB.

That is a bad thing to do in any case ;-)

But yeah, they'll stay around. In 7.3 and later, they will get cleaned
out eventually (whenever someone next uses the same temp schema).

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew L. Gould 2003-09-09 20:57:05 Re: Find overlapping time intervals, how?
Previous Message Darko Prenosil 2003-09-09 20:41:51 Re: Picture with Postgres and Delphi