On Thu, Jul 15, 2010 at 12:35 PM, Ben Chobot wrote:
> On Jul 15, 2010, at 9:30 AM, Scott Carey wrote:
>
> >> Many raid controllers are smart enough to always turn off write caching
> on the drives, and also disable the feature on their own buffer without a
> BBU. Add a BBU, and the cache on the c
lushing its buffers.
> >
> > Craig
> >
> >>
> >> -Original Message-
> >> From: pgsql-performance-ow...@postgresql.org
> >> [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Craig
> James
> >> Sent: Thursday, July
On Fri, Jul 9, 2010 at 2:38 AM, Samuel Gendler wrote:
> On Fri, Jul 9, 2010 at 2:08 AM, Russell Smith wrote:
> > On 09/07/10 02:31, Ryan Wexler wrote:
> >
> >
> > The only other difference between the boxes is the postgresql version.
> The
> > new one has 8.4
On Thu, Jul 8, 2010 at 12:13 PM, Jochen Erwied <
joc...@pgsql-performance.erwied.eu> wrote:
> Thursday, July 8, 2010, 7:16:47 PM you wrote:
>
> > Thanks. The server is hosted, so it is a bit of a hassle to figure this
> > stuff out, but I am having someone check.
>
> If you have root access to th
On Thu, Jul 8, 2010 at 12:46 PM, Kevin Grittner wrote:
> Ryan Wexler wrote:
>
> > One thing I don't understand is why BBU will result in a huge
> > performance gain. I thought BBU was all about power failures?
>
> Well, it makes it safe for the controller to con
On Thu, Jul 8, 2010 at 12:32 PM, Jochen Erwied <
joc...@pgsql-performance.erwied.eu> wrote:
> Thursday, July 8, 2010, 9:18:20 PM you wrote:
>
> > However, I just verified with the hosting company that BBU is off on the
> > raid controller. I am trying to find out my options, turn it on,
> differe
On Thu, Jul 8, 2010 at 12:13 PM, Jochen Erwied <
joc...@pgsql-performance.erwied.eu> wrote:
> Thursday, July 8, 2010, 7:16:47 PM you wrote:
>
> > Thanks. The server is hosted, so it is a bit of a hassle to figure this
> > stuff out, but I am having someone check.
>
> If you have root access to th
-- Forwarded message --
From: Ryan Wexler
Date: Thu, Jul 8, 2010 at 10:12 AM
Subject: Re: [PERFORM] performance on new linux box
To: Craig James
On Thu, Jul 8, 2010 at 10:10 AM, Craig James wrote:
> On 7/8/10 9:31 AM, Ryan Wexler wrote:
>
>> Thanks a lot for all
Thanks a lot for all the comments. The fact that both my windows box and
the old linux box both show a massive performance improvement over the new
linux box seems to point to hardware to me. I am not sure how to test the
fsync issue, but i don't see how that could be it.
The raid card the serve
Postgresql was previously running on a single cpu linux machine with 2 gigs
of memory and a single sata drive (v8.3). Basically a desktop with linux on
it. I experienced slow performance.
So, I finally moved it to a real server. A dually zeon centos machine with
6 gigs of memory and raid 10, po
10 matches
Mail list logo