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)
Виктор Судаков

November 2025

S M T W T F S
      1
2345678
9101112131415
16171819202122
23242526272829
30      

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Dec. 13th, 2025 08:29 pm
Powered by Dreamwidth Studios