Hi!
New btree code in CVS!
Sorry for lateness - it took 28 hours of continuous work +
3 hours of final tests.
All my tests are OK (I even played with 160000 of duplicates).
Also, I hope that variable-length attributes support improved -
at least the example below now works:
> bt=> create table test (x text);
> CREATE
> bt=> create index test_i on test (x);
> CREATE
> bt=> insert into test values ('0');
> INSERT 449464
> bt=> copy test from '/home/postgres/My/Btree/BUG/B';
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> 400 records with '12345'
> COPY
> bt=> vacuum verbose test;
> NOTICE:Rel test: Pages 4: Changed 4, Reapped 0, Empty 0, New 0; Tup 401: Vac 0, Crash 0, UnUsed 0, MinLen 53, MaxLen
57;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec.
> NOTICE:Ind test_i: Pages 5; Tuples 400. Elapsed 0/0 sec.
> NOTICE:Ind test_i: NUMBER OF INDEX' TUPLES (400) IS NOT THE SAME AS HEAP' (401)
> VACUUM
I posted new code to Michael and hope that he will test them soon
in real-life example.
Note, that for safety dump/initdb/reload required - previous fix
has bugs!
Vadim
------------------------------
