Re: BBU Cache vs. spindles

From: Rob Wultsch <wultsch(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Greg Smith <greg(at)2ndquadrant(dot)com>, jd(at)commandprompt(dot)com, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-performance(at)postgresql(dot)org, Ben Chobot <bench(at)silentmedia(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: BBU Cache vs. spindles
Date: 2010-10-23 04:07:49
Message-ID: AANLkTin8EmJk_9mNTJYxUVdekLvBN3wr-OyxHF6aNnq3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance pgsql-www

On Fri, Oct 22, 2010 at 1:15 PM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Rob Wultsch <wultsch(at)gmail(dot)com> wrote:
>
>> not needing full_page_writes would make geographically dispersed
>> replication possible for certain cases where it is not currently
>> (or at least rather painful).
>
> Do you have any hard numbers on WAL file size impact?  How much does
> pglesslog help in a file-based WAL transmission environment?  Should
> we be considering similar filtering for streaming replication?
>
> -Kevin
>

No, I am DBA that mostly works on MySQL. I have had to deal with
(handwaving...) tangential issues recently. I really would like to
work with PG more and this seems like it would be a significant
hindrance for certain usage patterns. Lots of replication does not
take place over gig...

--
Rob Wultsch
wultsch(at)gmail(dot)com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2010-10-23 16:41:33 Re: BBU Cache vs. spindles
Previous Message Kevin Grittner 2010-10-22 20:15:30 Re: BBU Cache vs. spindles

Browse pgsql-www by date

  From Date Subject
Next Message Josh Berkus 2010-10-23 21:03:06 Re: BBU Cache vs. spindles
Previous Message Magnus Hagander 2010-10-22 23:41:46 Re: Doc search fail