postgrespro / lsm3

LSM tree implementation based on standard B-Tree
Other
29 stars 1 forks source link

lsm3 index bloat? #1

Open digoal opened 4 years ago

digoal commented 4 years ago

HI, lsm3 index more larger than btree index:

postgres=# create index idx on t using lsm3(id) with (unique=true);
postgres=# insert into t select generate_series(1,10000000), md5(random()::text);

postgres=# \dt+ t
                           List of relations
 Schema | Name | Type  |  Owner   | Persistence |  Size  | Description 
--------+------+-------+----------+-------------+--------+-------------
 public | t    | table | postgres | permanent   | 651 MB | 

 public | idx              | index | postgres | t           | permanent   | 69 GB      | 
knizhnik commented 4 years ago

Fixed in 9348b75