Re: fsync and battery-backed caches - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: fsync and battery-backed caches
Date
Msg-id 20060228172334.GV82012@pervasive.com
Whole thread Raw
In response to Re: fsync and battery-backed caches  (Javier Somoza <jsomoza@pandasoftware.es>)
Responses Re: fsync and battery-backed caches  (Javier Somoza <jsomoza@pandasoftware.es>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] temporary indexes
Next
From: "Kevin Grittner"
Date:
Subject: Re: [HACKERS] temporary indexes