Re: swapcache-style cache?

Поиск
Список
Период
Сортировка
От karavelov@mail.bg
Тема Re: swapcache-style cache?
Дата
Msg-id e64b68edea3782a53c548b77e1e1bc51.mailbg@mail.bg
обсуждение исходный текст
Ответ на swapcache-style cache?  (james <james@mansionfamily.plus.com>)
Список pgsql-hackers
----- Цитат от Andrea Suisani (sickpig@opinioni.net), на 28.02.2012 в 09:54 ----- <br /><br />> On 02/28/2012 04:52
AM,Rob Wultsch wrote: <br />>> On Wed, Feb 22, 2012 at 2:31 PM, james wrote: <br />>>> Has anyone
consideredmanaging a system like the DragonFLY swapcache for a <br />>>> DBMS like PostgreSQL? <br
/>>>><br />>> <br />>> https://www.facebook.com/note.php?note_id=388112370932 <br />>> <br
/>><br />> in the same vein: <br />> <br />> http://bcache.evilpiepirate.org/ <br />> <br />> from
themain page: <br />> <br />> "Bcache is a patch for the Linux kernel to use SSDs to cache other block devices.
It'sanalogous to L2Arc for ZFS, <br />> but Bcache also does writeback caching, and it's filesystem agnostic. It's
designedto be switched on with a minimum <br />> of effort, and to work well without configuration on any setup. By
defaultit won't cache sequential IO, just the random <br />> reads and writes that SSDs excel at. It's meant to be
suitablefor desktops, servers, high end storage arrays, and perhaps <br />> even embedded." <br />> <br />> it
wassubmitted to linux kernel mailing list a bunch of time, the last one: <br />> <br />>
https://lkml.org/lkml/2011/9/10/13<br />> <br />> <br />> Andrea <br />> <br /><br />I am successfully
usingfacebook's flashchache in write-through mode - so it speeds only reads. I have seen 3 times <br />increase on TPS
fordatabases that do not fit in RAM. I am using Intel X-25E over RAID10 of 4 SAS disks. I have tested also <br
/>writebackmode but the gain is not so huge and there is a considerable risk for loosing all your data if/when the SSD
fails.<br /><br />Best regards <br /><br /><br />-- <br />Luben Karavelov 

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Initial 9.2 pgbench write results
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: review: CHECK FUNCTION statement