Re: Help me recovering data - Mailing list pgsql-hackers

From pgsql@mohawksoft.com
Subject Re: Help me recovering data
Date
Msg-id 16742.24.91.171.78.1108644470.squirrel@mail.mohawksoft.com
Whole thread Raw
In response to Re: Help me recovering data  (Greg Stark <gsstark@mit.edu>)
Responses Re: Help me recovering data
List pgsql-hackers
> Gaetano Mendola <mendola@bigfoot.com> writes:
>
>> We do ~4000 txn/minute so in 6 month you are screewd up...
>
> Sure, but if you ran without vacuuming for 6 months, wouldn't you notice
> the
> huge slowdowns from all those dead tuples before that?
>
>
I would think that only applies to databases where UPDATE and DELETE are
done often. What about databases that are 99.999% inserts? A DBA lightly
going over the docs may not even know that vacuum needs to be run.


pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas DAZ SD"
Date:
Subject: Re: Design notes for BufMgrLock rewrite
Next
From: "Merlin Moncure"
Date:
Subject: Re: win32 performance - fsync question