Index space reusable?

[lnd@hnit.is]

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 YourEmailAddres sHere" to majordomo@postg resql.org)

[Dennis Bjorklund]

Re: Index space reusable?

On Fri, 16 Jan 2004 lnd@hnit.is wrote:
[color=blue]
> do indexes tend to grow unless rebuilded under postgreSql?[/color]

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 majordomo@postg resql.org so that your
message can get through to the mailing list cleanly