management of pg-schemas: pg_temp_n and pg_toast_n ?

From: Mark Rostron <mrostron(at)ql2(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: management of pg-schemas: pg_temp_n and pg_toast_n ?
Date: 2010-09-18 18:41:13
Message-ID: FD020D3E50E7FA479567872E5F5F31E30459FB4D73@ex01.corp.ql2.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

This is occurring In an 8.4.2 pg database, and I have noticed it in 8.3.10 as well.
We do a lot of work with temp tables here, and over time a lot of pg_temp_[n] schemas have appeared.
Similarly, we notice build-up of pg_toast_[n] schemas.

Is it ok to drop these if they contain no tables?
Or is there a way to prevent them from persisting past a given life-time??

Mr

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-09-18 18:50:07 Re: management of pg-schemas: pg_temp_n and pg_toast_n ?
Previous Message Greg Smith 2010-09-18 07:48:50 Re: files under pg_clog directories are missing