| From: | George Neuner <gneuner2(at)comcast(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL Portable |
| Date: | 2014-09-11 07:16:42 |
| Message-ID: | 03h21a90gpqmhc7n438n2slj151mdpcb7c@4ax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 10 Sep 2014 14:19:45 -0700, John R Pierce
<pierce(at)hogranch(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Huang, Suya | 2014-09-11 07:21:57 | Re: Introducing Open PostgreSQL Monitoring (OPM) |
| Previous Message | Karsten Hilbert | 2014-09-11 07:14:55 | Re: PostgreSQL Portable |