Search

5-3-4. 너무 많은 인덱스의 위험성

-- [SQL-5-3-4-a] SELECT REPLACE(t1.indexname,t1.tablename||'_' ,'') ix ,pg_size_pretty(pg_relation_size((t1.schemaname || '.' || t1.indexname)::regclass)) ix_size ,t1.indexdef FROM pg_indexes t1 WHERE t1.tablename = 'tr_ord_big' ORDER BY t1.indexname;
SQL
복사
-- [SQL-5-3-4-b] SELECT pg_size_pretty(pg_relation_size('startdbpg.tr_ord_big'::regclass)) tab_size;
SQL
복사