On Wed, 10 Sep 2014 14:19:45 -0700, John R Pierce <pie...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
