From: Michael Stone
Subject: Re: PG8 Tuning
Date: ,
Msg-id: 20050811140704.GL19080@mathom.us
(view: Whole thread, Raw)
In response to: PG8 Tuning  ("Paul Johnson")
List: pgsql-performance

Tree view

PG8 Tuning  ("Paul Johnson", )
 Re: PG8 Tuning  (Richard Huxton, )
 [SPAM?] Re: PG8 Tuning  (Steve Poe, )
  Re: [SPAM?] Re: PG8 Tuning  ("Jeffrey W. Baker", )
   Re: [SPAM?] Re: PG8 Tuning  (Jeff Trout, )
   Re: [SPAM?] Re: PG8 Tuning  (Josh Berkus, )
    Re: [SPAM?] Re: PG8 Tuning  (Alvaro Herrera <-ip.org>, )
     Re: [SPAM?] Re: PG8 Tuning  ("Joshua D. Drake", )
     Re: PG8 Tuning  (John A Meinel, )
      Re: PG8 Tuning  (Tom Lane, )
       Re: PG8 Tuning  (John A Meinel, )
        Re: PG8 Tuning  (Tom Lane, )
    Re: [SPAM?] Re: PG8 Tuning  (Michael Stone, )
     Re: PG8 Tuning  (Josh Berkus, )
  Re: [SPAM?] Re: PG8 Tuning  (Tom Arthurs, )
  Re: PG8 Tuning  (Mark Lewis, )
   Re: PG8 Tuning  (Michael Stone, )
 Re: PG8 Tuning  (Michael Stone, )
 Re: PG8 Tuning  ("Merlin Moncure", )

On Thu, Aug 11, 2005 at 01:23:21PM +0100, Paul Johnson wrote:
>I'm guessing that this is because pg_xlog has gone from a 9 spindle LUN to
>a single spindle disk?
>
>In cases such as this, where an external storage array with a hardware
>RAID controller is used, the normal advice to separate the data from the
>pg_xlog  seems to come unstuck

Yes. That's the downside to dogma. If you're writing pg_xlog to a
battery-backed ram buffer you'll see faster commits than you will with a
write to a disk, even if you've got a dedicated spindle, unless you've
got constant write activity. (Because once the buffer fills you're
limited to disk speed as you wait for buffer flushes.) If you've got a
lot of system RAM, a battery-backed disk buffer, an OS/filesystem than
effectively delays writes, and bursty transactional writes it's quite
possible you'll get better performance putting everything on one array
rather than breaking it up to follow the "rules". You might get a
performance boost by putting the transaction log on a seperate partition
or lun on the external array, depending on how the fs implements syncs
or whether you can optimize the filsystem choice for each partition. The
correct approach is to run comparative benchmarks of each configuration.
:-)

Mike Stone


pgsql-performance by date:

From: "Merlin Moncure"
Date:
Subject: Re: PG8 Tuning
From: Alvaro Herrera
Date:
Subject: Re: Odd Locking Problem