By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,372 Members | 1,906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,372 IT Pros & Developers. It's quick & easy.

Index space reusable?

P: n/a
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)

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.