Thread: Index space reusable?

Any information how index space is managed when records are updated/deleted:

    do indexes tend to grow unless rebuilded under postgreSql?
(at least this is the case in commercial RDBMS Oracle: deletes/updates can
cause 24MB index on 10k table)?

Thank you in advance,
Laimis
Reykjavik, Iceland

On Fri, 16 Jan 2004 lnd@hnit.is wrote:

>     do indexes tend to grow unless rebuilded under postgreSql?

In pg 7.3 and older, yes. In 7.4 it should not be a problem any more. I
think it can grow a little even in 7.4, but it should be much better then
in 7.3. Or maybe all the growth was taken care of in 7.4 and I just don't
know about it.

--
/Dennis Björklund