Oct. 29th, 2015

victor_sudakov: (Default)
select oid, datname from pg_database;

cd /usr/local/pgsql/data/base/58484
du -s * | sort -n

select relname from pg_class where relfilenode = <числовое_имя_большого_файла>;
alter table XXX set tablespace d02;
alter index YYY set tablespace d02;

Profile

victor_sudakov: (Default)
Виктор Судаков

December 2024

S M T W T F S
1234567
891011121314
15161718192021
22232425262728
293031    

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Aug. 27th, 2025 04:31 pm
Powered by Dreamwidth Studios