Re: Update on putting WAL on ramdisk/

Поиск
Список
Период
Сортировка
От Russell Garrett
Тема Re: Update on putting WAL on ramdisk/
Дата
Msg-id MKEGJINFADFODDNOKEJCIEEFEMAA.rg@tcslon.com
обсуждение исходный текст
Ответ на Update on putting WAL on ramdisk/  (William Yu <wyu@talisys.com>)
Ответы Re: Update on putting WAL on ramdisk/  (William Yu <wyu@talisys.com>)
Список pgsql-performance
> WAL on single drive: 7.990 rec/s
> WAL on 2nd IDE drive: 8.329 rec/s
> WAL on tmpfs: 13.172 rec/s
>
> A huge jump in performance but a bit scary having a WAL that can
> disappear at any time. I'm gonna workup a rsync script and do some
> power-off experiments to see how badly it gets mangled.

Surely this is just equivalent to disabling fsync? If you put a WAL on a
volatile file system, there's not a whole lot of point in having one at all.

--------------------------------------------------------------------
Russ Garrett                                            russ@last.fm
                                                      http://last.fm


В списке pgsql-performance по дате отправления:

Предыдущее
От: William Yu
Дата:
Сообщение: Update on putting WAL on ramdisk/
Следующее
От: William Yu
Дата:
Сообщение: Re: Update on putting WAL on ramdisk/