find objects stored on a specific tablespace

Поиск
Список
Период
Сортировка
Искать

find objects stored on a specific tablespace

От:
"Ghiurea, Isabella" <Isabella.Ghiurea@nrc-cnrc.gc.ca>
Дата:

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

Re: find objects stored on a specific tablespace

От:
"David G. Johnston" <david.g.johnston@gmail.com>
Дата:
On Wed, Jul 18, 2018 at 10:06 AM, Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca> wrote:

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?

"pg_class.​​reltablespace" linking to "pg_tablespace"

David J.

FAQ