amcheck-compress-test.sql

application/octet-stream

Filename: amcheck-compress-test.sql
Type: application/octet-stream
Part: 0
Message: Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index.
drop table if exists descnums;
create table descnums(nums int4);
create index idx_desc_nl on descnums (nums desc nulls last);
create extension if not exists amcheck;
insert into descnums select case when i % 8 = 0 then i else NULL end from generate_series(0,2000) i;
select bt_index_parent_check('idx_desc_nl');