pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim C. Nasby <jnasby@pervasive.com>
To: Javier Somoza <jsomoza@pandasoftware.es>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Tino Wildenhain <tino@wildenhain.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: fsync and battery-backed caches
Date: Tue, 28 Feb 2006 11:23:34 -0600
Message-ID: <20060228172334.GV82012@pervasive.com> (raw)
In-Reply-To: <1141114775.1555.7.camel@pndsoft>
References: <200602280106.k1S16DK16068@candle.pha.pa.us>
	<1141114775.1555.7.camel@pndsoft>

Actually, you can't assume that a BBU means you can safely disable
full-page-writes. Depending on the controller, it's still possible to
end up with partially written pages.

BTW, if your mailer makes doing so convenient, it would be nice to trim
down your .signature; note that it's about 3x longer than the email you
actually sent.

On Tue, Feb 28, 2006 at 09:19:36AM +0100, Javier Somoza wrote:
> 
>             Yeah, i saw it. It says full-page-writes can be disabled
> without problems.
>             But i wanted to confirm fsync cannot be disabled although i
> have battery.
> 
>             Thanks!!   :-)
> 
> 
> 
> > We do mention battery-backed cache in our docs:
> > 
> > 	http://www.postgresql.org/docs/8.1/static/wal.html
> > 
> > If it is unclear, please let us know.
> 
> Javier Somoza
> Oficina de Direcci?n Estrat?gica
> mailto:jsomoza@pandasoftware.es
> 
> Panda Software
> Buenos Aires, 12
> 48001 BILBAO - ESPA?A
> Tel?fono: 902 24 365 4
> Fax:  94 424 46 97
> http://www.pandasoftware.es
> Panda Software, una de las principales compa??as desarrolladoras de
> soluciones de protecci?n contra virus e intrusos, presenta su nueva
> familia de soluciones. Todos los usuarios de ordenadores, desde las
> redes m?s grandes a los dom?sticos, disponen ahora de nuevos productos
> con excelentes tecnolog?as de seguridad. M?s informaci?n en:
> http://www.pandasoftware.es/productos
> 
>         
> 
> ?Prot?jase ahora contra virus e intrusos! Pruebe gratis nuestros
> productos en http://www.pandasoftware.es/descargas/
> 
>                 
>                 
>         
>         
>         
>         
>         
>         

-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



view thread (8+ messages)  latest in thread

Message-ID: <20060228172334.GV82012@pervasive.com>
Permalink:  ../20060228172334.GV82012@pervasive.com/
Also on:    postgresql.org/message-id/20060228172334.GV82012@pervasive.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jnasby@pervasive.com, jsomoza@pandasoftware.es, pgman@candle.pha.pa.us, tino@wildenhain.de
  Subject: Re: fsync and battery-backed caches
  In-Reply-To: <20060228172334.GV82012@pervasive.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox