Re: [PERFORM] performance on new linux box

2010-07-16 Thread Ryan Wexler
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

Re: [PERFORM] performance on new linux box

2010-07-14 Thread Ryan Wexler
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

Re: [PERFORM] performance on new linux box

2010-07-11 Thread Ryan Wexler
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

Re: [PERFORM] performance on new linux box

2010-07-08 Thread Ryan Wexler
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

Re: [PERFORM] performance on new linux box

2010-07-08 Thread Ryan Wexler
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

Re: [PERFORM] performance on new linux box

2010-07-08 Thread Ryan Wexler
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

Re: [PERFORM] performance on new linux box

2010-07-08 Thread Ryan Wexler
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

Fwd: [PERFORM] performance on new linux box

2010-07-08 Thread Ryan Wexler
-- 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

Re: [PERFORM] performance on new linux box

2010-07-08 Thread Ryan Wexler
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

[PERFORM] performance on new linux box

2010-07-07 Thread Ryan Wexler
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