Postgres Pro
Downloads
Home   >   mailing lists

pg_temp.XX.0 - Mailing list pgsql-hackers

From Daniel Kalchev
Subject pg_temp.XX.0
Date
Msg-id 200204030609.g3369Yu00281@dcave.digsys.bg
Whole thread Raw
Responses Re: pg_temp.XX.0  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
I found out, that there are some probably temporary relations in one of my 
databases, with names (that show in vacuum verbose output) like 
pg_temp.12720.0.

Are these the result of CREATE TEMP TABLE or simmilar and if so, can such 
relations be safely dropped? Perhaps a good idea to add some vacuum 
functionality to do this.

Daniel

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Locale support is now on by default
Next
From: Bruce Momjian
Date:
Subject: Re: pg_temp.XX.0