procpid for temp schema

From: ashok raj <ashokexplorer(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: procpid for temp schema
Date: 2009-03-31 08:00:42
Message-ID: 399c75c20903310100q2dfb449cn3f501a58144baf4c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi ,

is there a way that we could find which procpid or connection that
has created a particular temporary schema (pg_temp_*) ?.

In one of our db a temporary schema (pg_temp_48) was using more
than 200GB of disk space and how to find the connection which has created
the temp schema, ?

--
Regards,
Ashokraj

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Abbott 2009-03-31 08:21:28 PG Patch
Previous Message toni hernández 2009-03-31 07:39:55 Re: copy command and column attribute