Re: PostgreSQL Reliability when fsync = false on Linux-XFS

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL Reliability when fsync = false on Linux-XFS
Дата
Msg-id 21373.1062683328@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgreSQL Reliability when fsync = false on Linux-XFS  (Sean Chittenden <sean@chittenden.org>)
Список pgsql-performance
Sean Chittenden <sean@chittenden.org> writes:
>> Just wonderin. What if you symlink WAL to a directory which is on
>> mounted USB RAM drive?

> USB 2.0 you mean?  It supposedly runs at 1394 speeds, but USB 1.0/1.1
> runs at 1MB/s under ideal circumstances... that's slower than even old
> IDE drives.

>> Will that increase any throughput?

> Probably not...

Also, doesn't flash memory have a very limited lifetime in write cycles?
Using it as WAL, you'd wear it out PDQ.

            regards, tom lane

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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: SELECT's take a long time compared to other DBMS
Следующее
От: "Relaxin"
Дата:
Сообщение: Re: SELECT's take a long time compared to other DBMS