PostgreSQL

컬럼 버킷수 변경 방법

WOOJIN24 2020. 8. 2. 15:27
 
    -- 컬럼 버킷수 변경
	alter table t4 alter column c1 set statistics 200 ;
    
    --변경 후 확인
    select attname, attstattarget from pg_attribute
    where attrelid = (select oid from pg_class where relname = 't4')
    and attname = 'c1' ;
SMALL