| Lists: | pgsql-performance |
|---|
| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Anyone tried Flashcache with PostgreSQL? |
| Date: | 2011-02-28 19:09:55 |
| Message-ID: | 4D6BF303.6020000@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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
| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Anyone tried Flashcache with PostgreSQL? |
| Date: | 2011-03-02 15:29:21 |
| Message-ID: | AANLkTim3aD4xBbxJG9+VhawNN0x2VN8qu853aiPhcXVU@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-performance |
On Mon, Feb 28, 2011 at 2:09 PM, Josh Berkus <josh(at)agliodbs(dot)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
| From: | Samuel Gendler <sgendler(at)ideasculptor(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Anyone tried Flashcache with PostgreSQL? |
| Date: | 2011-03-03 00:20:27 |
| Message-ID: | AANLkTim3hRDU5KZsXL34t7xAYdG5=HXR_tkC+E8McRCR@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-performance |
On Wed, Mar 2, 2011 at 7:29 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Mon, Feb 28, 2011 at 2:09 PM, Josh Berkus <josh(at)agliodbs(dot)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...
| From: | Arjen van der Meijden <acmmailing(at)tweakers(dot)net> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Anyone tried Flashcache with PostgreSQL? |
| Date: | 2011-03-03 08:15:03 |
| Message-ID: | 4D6F4E07.3060609@tweakers.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-performance |
On 2-3-2011 16:29 Robert Haas wrote:
> On Mon, Feb 28, 2011 at 2:09 PM, Josh Berkus<josh(at)agliodbs(dot)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
| From: | Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com> |
|---|---|
| To: | Arjen van der Meijden <acmmailing(at)tweakers(dot)net> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Anyone tried Flashcache with PostgreSQL? |
| Date: | 2011-03-07 15:48:07 |
| Message-ID: | AANLkTimiTFh20uo5gS7r0uA=ap42sX5Ta+8edDaOjTng@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-performance |
2011/3/3 Arjen van der Meijden <acmmailing(at)tweakers(dot)net>:
> On 2-3-2011 16:29 Robert Haas wrote:
>>
>> On Mon, Feb 28, 2011 at 2:09 PM, Josh Berkus<josh(at)agliodbs(dot)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