pg_temp.XX.0
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
You can stop the postmaster and start the postgres binary with the -O
flag and delete the pg_temp tables. We don't have a cleanup for these
failed backends but we should. Normally they are cleaned up.
---------------------------------------------------------------------------
Daniel Kalchev wrote:
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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026