Re: PostgreSQL Portable

Поиск
Список
Период
Сортировка
От George Neuner
Тема Re: PostgreSQL Portable
Дата
Msg-id 03h21a90gpqmhc7n438n2slj151mdpcb7c@4ax.com
обсуждение исходный текст
Ответ на PostgreSQL Portable  (Daniel Begin <jfd553@hotmail.com>)
Ответы Re: PostgreSQL Portable  (Craig Ringer <craig@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: PostgreSQL Portable
Следующее
От: "Huang, Suya"
Дата:
Сообщение: Re: Introducing Open PostgreSQL Monitoring (OPM)