Postgres Pro
Downloads
Home   >   mailing lists

find objects stored on a specific tablespace - Mailing list pgsql-admin

From Ghiurea, Isabella
Subject find objects stored on a specific tablespace
Date
Msg-id 1531933561900.95684@nrc-cnrc.gc.ca
Whole thread Raw
Responses Re: find objects stored on a specific tablespace
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: Naveen Kumar
Date:
Subject: WARNING: could not write block 27094490 of base/56972584/56980980
Next
From: Jorge Torralba
Date:
Subject: Re: ERROR: unexpected chunk number 452 (expected 0) for toast value94674063 in pg_toast_56980977