Re: Help me recovering data

From: pgsql(at)mohawksoft(dot)com
To: "Greg Stark" <gsstark(at)mit(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Help me recovering data
Date: 2005-02-17 12:47:50
Message-ID: 16742.24.91.171.78.1108644470.squirrel@mail.mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Gaetano Mendola <mendola(at)bigfoot(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2005-02-17 13:47:15 Re: win32 performance - fsync question
Previous Message Zeugswetter Andreas DAZ SD 2005-02-17 12:05:43 Re: Design notes for BufMgrLock rewrite