SOL>SELECT oid , spcname FROM pg_tablespace;SOL>SELECT pg_tablespace_location(tablespace_oid);2、查看表空间已占用的空间大小SOL>SELECT pg_size_pretty(pg_tablespace size('pg_default'));表空间大小不设上限,无其他文件抢占的时候能占满所在磁盘。3、查看表占用的空间大小SOL>SELECT t name, pg_size_pretty(pg_relation size(t name)) FROM (VALUES('store sales'),('date dim'),('store')) AS names1(t name);