find objects stored on a specific tablespace

From: "Ghiurea, Isabella" <Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: find objects stored on a specific tablespace
Date: 2018-07-18 17:06:02
Message-ID: 1531933561900.95684@nrc-cnrc.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Gurus

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

thank you

Isabella

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jorge Torralba 2018-07-18 17:09:30 Re: ERROR: unexpected chunk number 452 (expected 0) for toast value 94674063 in pg_toast_56980977
Previous Message Naveen Kumar 2018-07-18 17:02:25 WARNING: could not write block 27094490 of base/56972584/56980980