Re: XLog vs SSD [Was: Re: random write in xlog?]

Поиск
Список
Период
Сортировка
От James Cloos
Тема Re: XLog vs SSD [Was: Re: random write in xlog?]
Дата
Msg-id m3pqtayhv6.fsf@jhcloos.com
обсуждение исходный текст
Ответ на Re: XLog vs SSD [Was: Re: random write in xlog?]  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
>>>>> "JJ" == Jeff Janes <jeff.janes@gmail.com> writes:

JJ> So PG always writing 8K at a time is unlikely to make a difference
JJ> than if it wrote a smaller amount.

Ah.

Somehow I was thinking of the xlog files' 16M filesize rather than the
internal 8k block size....

If it is only writing 8k blocks then there is probably little hope of
making efficient use of flash.

-JimC
-- 
James Cloos <cloos@jhcloos.com>         OpenPGP: 1024D/ED7DAEA6


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

Предыдущее
От: "BRUSSER Michael"
Дата:
Сообщение: initdb failure with Postgres 8.4.4
Следующее
От: Gurjeet Singh
Дата:
Сообщение: Re: Patch to add a primary key using an existing index