Received: from malur.postgresql.org ([2a02:16a8:dc51::56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1ffpuS-000609-KY
	for pgsql-admin@arkaria.postgresql.org; Wed, 18 Jul 2018 17:06:44 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1ffpuA-0007iD-T5
	for pgsql-admin@arkaria.postgresql.org; Wed, 18 Jul 2018 17:06:22 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <Isabella.Ghiurea@nrc-cnrc.gc.ca>)
	id 1ffpuA-0007i1-1B
	for pgsql-admin@lists.postgresql.org; Wed, 18 Jul 2018 17:06:22 +0000
Received: from mx.ssan.egs-seg.gc.ca ([205.193.229.132])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <Isabella.Ghiurea@nrc-cnrc.gc.ca>)
	id 1ffptu-0002IG-HX
	for pgsql-admin@postgresql.org; Wed, 18 Jul 2018 17:06:08 +0000
Received: from DC01ZWH0021.corp.nrc.gc.ca ([167.37.58.17])
	by mx.ssan.egs-seg.gc.ca  with ESMTP id w6IH62Gl028207-w6IH62Go028207
	(version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA bits=256 verify=CAFAIL)
	for <pgsql-admin@postgresql.org>; Wed, 18 Jul 2018 13:06:02 -0400
Received: from DC01ZWH0015.Corp.nrc.gc.ca (167.37.54.209) by
 DC01ZWH0021.Corp.nrc.gc.ca (167.37.58.17) with Microsoft SMTP Server (TLS) id
 15.0.1347.2; Wed, 18 Jul 2018 13:05:59 -0400
Received: from DC01ZWH0011.Corp.nrc.gc.ca (167.37.54.205) by
 DC01ZWH0015.Corp.nrc.gc.ca (167.37.54.209) with Microsoft SMTP Server (TLS)
 id 15.0.1347.2; Wed, 18 Jul 2018 13:06:02 -0400
Received: from DC01ZWH0011.Corp.nrc.gc.ca ([167.37.54.205]) by
 DC01ZWH0011.Corp.nrc.gc.ca ([167.37.54.205]) with mapi id 15.00.1347.000;
 Wed, 18 Jul 2018 13:06:02 -0400
From: "Ghiurea, Isabella" <Isabella.Ghiurea@nrc-cnrc.gc.ca>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: find objects stored on a specific tablespace
Thread-Topic: find objects stored on a specific tablespace
Thread-Index: AQHUHrkhcqyceKxd1EC/3Yo86o1zOA==
Date: Wed, 18 Jul 2018 17:06:02 +0000
Message-ID: <1531933561900.95684@nrc-cnrc.gc.ca>
Accept-Language: en-US, en-CA
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
x-ms-exchange-transport-fromentityheader: Hosted
x-originating-ip: [167.37.48.8]
Content-Type: multipart/alternative;
	boundary="_000_153193356190095684nrccnrcgcca_"
MIME-Version: 1.0
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

--_000_153193356190095684nrccnrcgcca_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Gurus

I am looking to drop  a  user tablespace  I need to find and confirm if the=
re are any and which  tables+indexers  still using this  tablespace, what p=
g view and statement will give me this information?


thank you

Isabella

--_000_153193356190095684nrccnrcgcca_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none"><!--P{margin-top:0;margin-b=
ottom:0;} --></style>
</head>
<body dir=3D"ltr" style=3D"font-size:12pt;color:#000000;background-color:#F=
FFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hi Gurus</p>
<p>I am looking to drop &nbsp;a &nbsp;user tablespace&nbsp; I need to find =
and confirm if there are any and which&nbsp; tables&#43;indexers&nbsp; stil=
l using this&nbsp; tablespace,&nbsp;what pg view and statement will&nbsp;gi=
ve me this information?</p>
<p><br>
</p>
<p>thank you</p>
<p>Isabella <br>
</p>
</body>
</html>

--_000_153193356190095684nrccnrcgcca_--