Index space reusable?

[lnd]

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Dennis Bjorklund]

On Fri, 16 Jan 2004 ln*@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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly