Re: Frequently updated tables - Mailing list pgsql-hackers

From Mark Kirkwood
Subject Re: Frequently updated tables
Date
Msg-id 40C65FD8.2030104@coretech.co.nz
Whole thread Raw
In response to Re: Frequently updated tables  (pgsql@mohawksoft.com)
Responses Re: Frequently updated tables
List pgsql-hackers
pgsql@mohawksoft.com wrote:

>The best phrasing would be "the accumulating overhead of deletes and
>updates."
>
>Yes.
>  
>

Are you using 7.3?

I am asking because in 7.3 high update / delete tables could suffer 
(index and toast) bloat that was untamable via (lazy) VACUUM and FSM.
I believe this is fixed in 7.4, so it should be possible to achieve on 
disk size control of tables / indexes by configuring FSM and (lazy) 
VACUUM. Did you find this not to be the case?

regards

Mark


pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: [pgsql-www] Collaboration Tool Proposal
Next
From: Bruce Momjian
Date:
Subject: Re: bug in 7.4 SET WITHOUT OIDs