Thread: how can i UPDATE without dead rows

<p>Hi!<p><br /><p>My program must use UPDATE usualy, and there will be many dead rows in this table <p>what throttle
downthe db server. I would like to update so not create dead row.<p>How can i do this?<p><br /><p>sorry for my english
:)<p><aclass="RVTS7" href="mailto:csepinek@freemail.hu"><br /></a> 

csepinek@freemail.hu 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