Tom Lane <[EMAIL PROTECTED]>:
> Atsushi Ogawa <[EMAIL PROTECTED]> writes:
> > When _bt_check_unique finds a dead item that has same data as new
> > item, LP_DEAD is set to the item. Can we reuse this dead item instead
> > of inserting new item?
>
> This strikes me as a pretty bad idea for the same
Atsushi Ogawa <[EMAIL PROTECTED]> writes:
> When _bt_check_unique finds a dead item that has same data as new
> item, LP_DEAD is set to the item. Can we reuse this dead item instead
> of inserting new item?
This strikes me as a pretty bad idea for the same reason pointed out
recently in other thre
When _bt_check_unique finds a dead item that has same data as new
item, LP_DEAD is set to the item. Can we reuse this dead item instead
of inserting new item? If it is possible, the growth of btree index
can be reduced.
I think it is effective in the table like branches table of pgbench to
which t
