Re: moving pg_xlog -- yeah, it's worth it!

From: Kevin Grittner
Subject: Re: moving pg_xlog -- yeah, it's worth it!
Date: ,
Msg-id: 4B73EE95020000250002F1CC@gw.wicourts.gov
(view: Whole thread, Raw)
In response to: Re: moving pg_xlog -- yeah, it's worth it!  ("Kevin Grittner")
Responses: Re: moving pg_xlog -- yeah, it's worth it!  (Alvaro Herrera)
List: pgsql-performance

Tree view

moving pg_xlog -- yeah, it's worth it!  ("Kevin Grittner", )
 Re: moving pg_xlog -- yeah, it's worth it!  (Jesper Krogh, )
  Re: moving pg_xlog -- yeah, it's worth it!  ("Kevin Grittner", )
   Re: moving pg_xlog -- yeah, it's worth it!  (Amitabh Kant, )
    Re: moving pg_xlog -- yeah, it's worth it!  ("Kevin Grittner", )
   Re: moving pg_xlog -- yeah, it's worth it!  (Bruce Momjian, )
    Re: moving pg_xlog -- yeah, it's worth it!  (Scott Marlowe, )
   Re: moving pg_xlog -- yeah, it's worth it!  ("Kevin Grittner", )
    Re: moving pg_xlog -- yeah, it's worth it!  (Alvaro Herrera, )
     Re: moving pg_xlog -- yeah, it's worth it!  (Aidan Van Dyk, )
      Re: moving pg_xlog -- yeah, it's worth it!  ("Kevin Grittner", )
 Re: moving pg_xlog -- yeah, it's worth it!  ("Kevin Grittner", )
  Re: moving pg_xlog -- yeah, it's worth it!  (Alvaro Herrera, )
   Re: moving pg_xlog -- yeah, it's worth it!  (Alvaro Herrera, )
    Re: moving pg_xlog -- yeah, it's worth it!  ("Kevin Grittner", )
     Re: moving pg_xlog -- yeah, it's worth it!  (Alvaro Herrera, )
  Re: moving pg_xlog -- yeah, it's worth it!  (Greg Smith, )
   Re: moving pg_xlog -- yeah, it's worth it!  ("Kevin Grittner", )
    Re: moving pg_xlog -- yeah, it's worth it!  (Ben Chobot, )

"Kevin Grittner" <> wrote:
> Jesper Krogh <> wrote:
>
>> Sorry if it is obvious.. but what filesystem/OS are you using and
>> do you have BBU-writeback on the main data catalog also?

> File system is xfs noatime,nobarrier for all data; OS is on ext3.
> I *think* the pg_xlog mirrored pair is hanging off the same
> BBU-writeback controller as the big RAID, but I'd have to track
> down the hardware tech to confirm

Another example of why I shouldn't trust my memory.  Per the
hardware tech:


OS:      /dev/sda   is RAID1  -  2  x  2.5" 15k SAS disk
pg_xlog: /dev/sdb   is RAID1  -  2  x  2.5" 15k SAS disk

These reside on a ServeRAID-MR10k controller with 256MB BB cache.


data:    /dev/sdc   is RAID5  -  30 x 3.5" 15k SAS disk

These reside on the DS3200 disk subsystem with 512MB BB cache per
controller and redundant drive loops.


At least I had the file systems and options right.  ;-)

-Kevin


pgsql-performance by date:

From: Scott Marlowe
Date:
Subject: Re: Dell PERC H700/H800
From: "Joshua D. Drake"
Date:
Subject: Re: Dell PERC H700/H800