Re: Frequently updated tables

From: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>
To: pgsql(at)mohawksoft(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Frequently updated tables
Date: 2004-06-09 00:54:48
Message-ID: 40C65FD8.2030104@coretech.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


pgsql(at)mohawksoft(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-06-09 01:32:51 Re: bug in 7.4 SET WITHOUT OIDs
Previous Message Larry Rosenman 2004-06-09 00:27:52 Re: [HACKERS] Collaboration Tool Proposal