lsm3 icon indicating copy to clipboard operation
lsm3 copied to clipboard

lsm3 index bloat?

Open digoal opened this issue 5 years ago • 1 comments

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      | 

digoal avatar Aug 07 '20 07:08 digoal

Fixed in 9348b75

knizhnik avatar Aug 07 '20 20:08 knizhnik