Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-performance-owner+M48651=pgsql-performance-ar@postgresql.org>)
	id 1TdbOV-0005zK-3N for pgsql-performance@arkaria.postgresql.org;
	Wed, 28 Nov 2012 06:45:16 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-performance-owner+M48651=pgsql-performance-ar@postgresql.org>)
	id 1TdbOU-0002XM-Hg for pgsql-performance@arkaria.postgresql.org;
	Wed, 28 Nov 2012 06:45:14 +0000
Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <suhas.b@verse.in>) id 1TdbOS-0002WM-UI
	for pgsql-performance@postgresql.org; Wed, 28 Nov 2012 06:45:13 +0000
Received: from sam.nabble.com ([216.139.236.26])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <suhas.b@verse.in>) id 1TdbOR-0005c9-Oa
	for pgsql-performance@postgresql.org; Wed, 28 Nov 2012 06:45:12 +0000
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <suhas.b@verse.in>) id 1TdbOR-0001kA-1G
	for pgsql-performance@postgresql.org; Tue, 27 Nov 2012 22:45:11 -0800
Date: Tue, 27 Nov 2012 22:45:11 -0800 (PST)
From: "suhas.basavaraj12" <suhas.b@verse.in>
To: pgsql-performance@postgresql.org
Message-ID: <1354085111032-5733858.post@n5.nabble.com>
Subject: pgsql_tmp( Temporary tablespace)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -0.8 (/)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Hi,

This folde( Temporary tablespace) is getting filled and size increases in
the day where there lots of sorting operations.But after some times the data
in the is deleted automatically .  Can any one explain what is going on ?

Rgrds
Suhas



--
View this message in context: http://postgresql.1045698.n5.nabble.com/pgsql-tmp-Temporary-tablespace-tp5733858.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance