Re: Anyone tried Flashcache with PostgreSQL? - Mailing list pgsql-performance

From Cédric Villemain
Subject Re: Anyone tried Flashcache with PostgreSQL?
Date
Msg-id AANLkTimiTFh20uo5gS7r0uA=ap42sX5Ta+8edDaOjTng@mail.gmail.com
Whole thread Raw
In response to Re: Anyone tried Flashcache with PostgreSQL?  (Arjen van der Meijden <acmmailing@tweakers.net>)
List 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 by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Performance issues
Next
From: Jon Nelson
Date:
Subject: plan variations: join vs. exists vs. row comparison