Обсуждение: Anyone tried Flashcache with PostgreSQL?
Hey, 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 ... -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com
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? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Wed, Mar 2, 2011 at 7:29 AM, Robert Haas <robertmhaas@gmail.com> wrote:
On Mon, Feb 28, 2011 at 2:09 PM, Josh Berkus <josh@agliodbs.com> wrote:It'd be a lot more interesting if it were a write-through cache rather
> 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 ...
than a write-back cache, wouldn't it?
Well, it is open source...
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. Best regards, Arjen
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