kingbaseESV8 toast存储

create table public.blog(id int ,name text);

select relname,relfilenode,reltoastrelid from sys_class where relname='blog';

test=# select relname,relfilenode,reltoastrelid from sys_class where relname='blog';                
 relname | relfilenode | reltoastrelid 
---------+-------------+---------------
 blog    |       16489 |         16492
(1 行记录)

alter table public.blog alter name set storage extended;
plain     --不压缩，不允许行外存储
extended  --默认，压缩，行外存储
external  --不压缩，行外存储
main      --压缩，不允许行外存储

select repeat(md5(random()::text),100000) from generate_series(1,1);

select relname,relfilenode,reltoastrelid from sys_class where relname='pg_toast_16489_index';

select relname,relfilenode,reltoastrelid from sys_class where relname='pg_toast_16489';

test=# select relname,relfilenode,reltoastrelid from sys_class where relname='pg_toast_16489';
    relname     | relfilenode | reltoastrelid 
----------------+-------------+---------------
 pg_toast_16489 |       16492 |             0
(1 行记录)

test=#