Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 4641F63345E for ; Tue, 31 Mar 2009 05:08:24 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 36860-02 for ; Tue, 31 Mar 2009 05:08:11 -0300 (ADT) X-Greylist: delayed 00:07:30.299491 by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.174]) by mail.postgresql.org (Postfix) with ESMTP id 10F54632E69 for ; Tue, 31 Mar 2009 05:08:13 -0300 (ADT) Received: by wf-out-1314.google.com with SMTP id 29so2794745wff.28 for ; Tue, 31 Mar 2009 01:08:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=i8Z2MU0Usf4k/bD8pNMtFV3HJQ+lfxA6eV9fnexduoo=; b=AmrA2NHAmfVOOAX2MY7W87vmjMcrIl4D5djveXKrWU3G6zE0pNkPKW6oTh48HTnjin CjdJLIYPJJREATBrQfGz9EATmPAqN7UFWgH+9NRQKfTvQPdXd5F1IlmrpDaMSEJAPKuH dgQc9333Q9s7m2f7MpBBtCesCc7fyhCbbWFi0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=qoJe2PKrGDTx/FpNQwyKf2lYEApN6F9PD/8HvpIhFv+fb962XyOugKCFN49C2vTSIM iXvTxAAkko0X6GlXZj6kUz+yi5M2fV/80sjLnH6RtOfB7UwPpjvp7R9RWWe9HhGfOKfz VRtVTFetr0s71W2Aw6aiR5VIk07wmXvy//VJo= MIME-Version: 1.0 Received: by 10.142.125.4 with SMTP id x4mr2515827wfc.75.1238486442472; Tue, 31 Mar 2009 01:00:42 -0700 (PDT) Date: Tue, 31 Mar 2009 13:30:42 +0530 Message-ID: <399c75c20903310100q2dfb449cn3f501a58144baf4c@mail.gmail.com> Subject: procpid for temp schema From: ashok raj To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=000e0cd2287c76763604666598ae X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200903/256 X-Sequence-Number: 31756 --000e0cd2287c76763604666598ae Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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 --000e0cd2287c76763604666598ae Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi ,

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

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

--
Regards,
Ashokraj


--000e0cd2287c76763604666598ae--