Dne 1.5.2011 05:30, Tom Lane napsal(a):
> Tomas Vondra writes:
>> testdb=# select bt_page_items('test_index', 3);
>> bt_page_items
>> --
>> (1,"(1,1)",8,f,f,"")
>> (2,"(2,1)",12,f,f,"ca 01 00 00")
>> (3,"(4,1)",12,f,f,"93 03 00 00")
>> (3 rows)
>
>> I
Tomas Vondra writes:
> testdb=# select bt_page_items('test_index', 3);
> bt_page_items
> --
> (1,"(1,1)",8,f,f,"")
> (2,"(2,1)",12,f,f,"ca 01 00 00")
> (3,"(4,1)",12,f,f,"93 03 00 00")
> (3 rows)
> I don't understand the first row and I've been unable
Hi,
when working on the integrity checking tool, I've noticed there are a
bit trange tuples in the btree indexes. E.g. if I do this:
create table test_table (id int);
insert into test_table select i from generate_series(1,1000) s(i);
create index test_index on test_table(id);
then pageinspect re
