Re: Maximum transaction rate

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Marco Colombo <pgsql(at)esiway(dot)net>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Christophe <xof(at)thebuild(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Maximum transaction rate
Date: 2009-03-14 14:59:54
Message-ID: 1237042794.25832.0.camel@jd-laptop.pragmaticzealot.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 2009-03-14 at 05:25 +0100, Marco Colombo wrote:
> Scott Marlowe wrote:

> Also see:
> http://lkml.org/lkml/2008/2/26/41
> but it seems to me that all this discussion is under the assuption that
> disks have write-back caches.
> "The alternative is to disable the disk write cache." says it all.

If this applies to raid based cache as well then performance is going to
completely tank. For users of Linux + PostgreSQL using LVM.

Joshua D. Drake

>
> .TM.
>
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message baptista 2009-03-14 17:17:44 Comemoracao Niver PH - 20, 21 e 22/03!
Previous Message Devrim GÜNDÜZ 2009-03-14 09:02:10 New shapshot RPMs (Mar 10, 2009) are ready for testing