Re: how can i UPDATE without dead rows - Mailing list pgsql-sql

From Richard Huxton
Subject Re: how can i UPDATE without dead rows
Date
Msg-id 42B2F5B1.5090203@archonet.com
Whole thread Raw
In response to how can i UPDATE without dead rows  (csepinek@freemail.hu)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Bricklen Anderson
Date:
Subject: Re: UPDATEABLE VIEWS ... Examples?
Next
From: grupos
Date:
Subject: Re: SELECT with sum on groups ORDERING by the subtotals