Re: autovacuum: 50% iowait for hours

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: autovacuum: 50% iowait for hours
Date: 2010-05-16 19:18:40
Message-ID: AANLkTilaouTmcDXPszJInonFEYYzhx5U56lmXmAQ1ACd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, May 16, 2010 at 12:32 PM, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:

> Just make sure you're producing good backups of these systems then.  You can
> expect to run into one of the data eating bugs in 8.1 eventually.  You'll
> probably have a corrupt database from the sort of fsync issues cheap storage
> introduces too.  Not upgrading from 8.1.4 is effectively saying "I don't
> care about the integrity of my database", so you really need to make
> alternate plans to help there.

I don't say this often, but "this".

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2010-05-16 19:19:23 Re: autovacuum: 50% iowait for hours
Previous Message Greg Smith 2010-05-16 18:32:24 Re: autovacuum: 50% iowait for hours