pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Anyone tried Flashcache with PostgreSQL?
5+ messages / 5 participants
[nested] [flat]

* Anyone tried Flashcache with PostgreSQL?
@ 2011-02-28 19:09  Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Josh Berkus @ 2011-02-28 19:09 UTC (permalink / raw)
  To: pgsql-performance

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Anyone tried Flashcache with PostgreSQL?
@ 2011-03-02 15:29  Robert Haas <robertmhaas@gmail.com>
  parent: Josh Berkus <josh@agliodbs.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Robert Haas @ 2011-03-02 15:29 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Anyone tried Flashcache with PostgreSQL?
@ 2011-03-03 00:20  Samuel Gendler <sgendler@ideasculptor.com>
  parent: Robert Haas <robertmhaas@gmail.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Samuel Gendler @ 2011-03-03 00:20 UTC (permalink / raw)
  To: Robert Haas <robertmhaas@gmail.com>; +Cc: Josh Berkus <josh@agliodbs.com>; pgsql-performance

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:
> > 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?
>

Well, it is open source...

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Anyone tried Flashcache with PostgreSQL?
@ 2011-03-03 08:15  Arjen van der Meijden <acmmailing@tweakers.net>
  parent: Robert Haas <robertmhaas@gmail.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Arjen van der Meijden @ 2011-03-03 08:15 UTC (permalink / raw)
  To: pgsql-performance

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Anyone tried Flashcache with PostgreSQL?
@ 2011-03-07 15:48  Cédric Villemain <cedric.villemain.debian@gmail.com>
  parent: Arjen van der Meijden <acmmailing@tweakers.net>
  0 siblings, 0 replies; 5+ messages in thread

From: Cédric Villemain @ 2011-03-07 15:48 UTC (permalink / raw)
  To: Arjen van der Meijden <acmmailing@tweakers.net>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2011-03-07 15:48 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-02-28 19:09 Anyone tried Flashcache with PostgreSQL? Josh Berkus <josh@agliodbs.com>
2011-03-02 15:29 ` Robert Haas <robertmhaas@gmail.com>
2011-03-03 00:20   ` Samuel Gendler <sgendler@ideasculptor.com>
2011-03-03 08:15   ` Arjen van der Meijden <acmmailing@tweakers.net>
2011-03-07 15:48     ` Cédric Villemain <cedric.villemain.debian@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox