Re: Anyone tried Flashcache with PostgreSQL?

Поиск
Список
Период
Сортировка
От Cédric Villemain
Тема Re: Anyone tried Flashcache with PostgreSQL?
Дата
Msg-id AANLkTimiTFh20uo5gS7r0uA=ap42sX5Ta+8edDaOjTng@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Anyone tried Flashcache with PostgreSQL?  (Arjen van der Meijden <acmmailing@tweakers.net>)
Список pgsql-performance
2011/3/3 Arjen van der Meijden <acmmailing@tweakers.net>:
> On 2-3-2011 16:29 Robert Haas wrote:
>>
>> On Mon, Feb 28, 2011 at 2:09 PM, Josh Berkus<josh@agliodbs.com>  wrote:
>>>
>>> Does anyone have the hardware to test FlashCache with PostgreSQL?
>>>
>>> http://perspectives.mvdirona.com/2010/04/29/FacebookFlashcache.aspx
>>>
>>> I'd be interested to hear how it performs ...
>>
>> It'd be a lot more interesting if it were a write-through cache rather
>> than a write-back cache, wouldn't it?
>
> That's what bcache tries to accomplish, both read and write cache.
> It also appears to aim to be more widely usable, rather than the relatively
> specific requirements the facebook variant is designed for.
>
> http://bcache.evilpiepirate.org/
>
> They seem to try and combine both the dedicated ZIL and L2ARC functionality
> from ZFS in one block device based caching layer.

Bcache looks more interesting, yes. Still it is not production ready
and get some dangerous caveeat with administration tasks (for example
remounting devices without their caches open the door of all evils).

--
Cédric Villemain               2ndQuadrant
http://2ndQuadrant.fr/     PostgreSQL : Expertise, Formation et Support

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

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: Performance issues
Следующее
От: Jon Nelson
Дата:
Сообщение: plan variations: join vs. exists vs. row comparison