[EMAIL PROTECTED] wrote:
Hi!
My program must use UPDATE usualy, and there will be many dead rows in this table
what throttle down the db server. I would like to update so not create dead row.
How can i do this?
You can't - that's how MVCC works. Make sure your free-space-map
settings are large enough in postgresql.conf and that you vacuum enough
- that will keep the "dead" space being re-used.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
