Re: PostgreSQL Portable - Mailing list pgsql-general

From George Neuner
Subject Re: PostgreSQL Portable
Date
Msg-id 03h21a90gpqmhc7n438n2slj151mdpcb7c@4ax.com
Whole thread Raw
In response to PostgreSQL Portable  (Daniel Begin <jfd553@hotmail.com>)
Responses Re: PostgreSQL Portable  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-general
On Wed, 10 Sep 2014 14:19:45 -0700, John R Pierce
<pierce@hogranch.com> wrote:

>also, Windows disables writeback caching on external disks, this will
>greatly slow down update transactions.

Not exactly.  By default, write caching is disabled for external
drives to support quick disconnect, i.e. yanking the device without
unmounting it.

If the driver permits it and you [or your users] can be trusted to
perform a safe unmount via the OS *before* disconnecting the device,
then you can enable write caching for the device using the device
manager.  [Note that the device must be connected for it to be visible
in the device manager.]

Most USB disks and Flash devices do support write caching.  If you are
willing to live dangerously, you can get better write performance.

George

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: PostgreSQL Portable
Next
From: "Huang, Suya"
Date:
Subject: Re: Introducing Open PostgreSQL Monitoring (OPM)