Release Notes
Product Announcements
unzip pg_repack-1.5.2.zipcd pg_repack-1.5.2make && make install
-- Check but not executepg_repack -k --dry-run --no-order -h 10.*.*.* -p 5432 -U user -d database -t schema1.table1-- Check and executepg_repack -k --no-order -h 10.*.*.* -p 5432 -U user -d database -t schema1.table1
-- Check but not executepg_repack -k --dry-run --no-order -h 10.*.*.* -p 5432 -U user -d database -c schema-- Check and executepg_repack -k --no-order -h 10.*.*.* -p 5432 -U user -d database -c schema
-- Check but not executepg_repack -k --dry-run --no-order -h 10.*.*.* -p 5432 -U user -d database-- Check and executepg_repack -k --no-order -h 10.*.*.* -p 5432 -U user -d database
-- Check but not executepg_repack -k --dry-run --no-order -h 10.*.*.* -p 5432 -U user -a-- Check and executepg_repack -k --no-order -h 10.*.*.* -p 5432 -U user -a
-- View the top library size, sql as follows:select datname,pg_size_pretty(pg_database_size(datname)) from pg_database order by pg_database_size(datname) desc;-- View the top table size in the database, sql as follows:SELECT relname AS table_name, pg_size_pretty(pg_total_relation_size(relid)) AS total_size FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;-- View the size of a specific table, sql as follows:select pg_size_pretty(pg_total_relation_size('pgtest'));
Apakah halaman ini membantu?
Anda juga dapat Menghubungi Penjualan atau Mengirimkan Tiket untuk meminta bantuan.
masukan