find objects stored on a specific tablespace

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "pgsql-admin@xxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxx>
Subject: find objects stored on a specific tablespace
From: "Ghiurea, Isabella" <Isabella.Ghiurea@xxxxxxxxxxxxxx>
Date: Wed, 18 Jul 2018 17:06:02 +0000

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

Follow-Ups:
- Re: find objects stored on a specific tablespace
  - From: David G. Johnston

Prev by Date: WARNING: could not write block 27094490 of base/56972584/56980980
Next by Date: Re: ERROR: unexpected chunk number 452 (expected 0) for toast value 94674063 in pg_toast_56980977
Previous by thread: WARNING: could not write block 27094490 of base/56972584/56980980
Next by thread: Re: find objects stored on a specific tablespace
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux