Postgres Professional
   

Re: partition question for new server setup

From: Kevin Grittner
Subject: Re: partition question for new server setup
Date: ,
Msg-id: 49F70513.EE98.0025.0@wicourts.gov
(view: Whole thread, Raw)
In response to: Re: partition question for new server setup  (Craig James)
Responses: Re: partition question for new server setup  (Kenneth Marshall)
List: pgsql-performance

Tree view

partition question for new server setup  (Whit Armstrong, )
 Re: partition question for new server setup  (Scott Marlowe, )
  Re: partition question for new server setup  (Whit Armstrong, )
   Re: partition question for new server setup  (Scott Marlowe, )
    Re: partition question for new server setup  (Kenneth Marshall, )
     Re: partition question for new server setup  (Craig James, )
      Re: partition question for new server setup  ("Kevin Grittner", )
       Re: partition question for new server setup  (Kenneth Marshall, )
        Re: partition question for new server setup  (Scott Marlowe, )
      Re: partition question for new server setup  (Whit Armstrong, )
       Re: partition question for new server setup  ("Kevin Grittner", )
        Re: partition question for new server setup  (Whit Armstrong, )
       Re: partition question for new server setup  (Scott Marlowe, )
      Re: partition question for new server setup  (Scott Carey, )
       Re: partition question for new server setup  (Whit Armstrong, )
        Re: partition question for new server setup  (Scott Carey, )
     Re: partition question for new server setup  (Scott Marlowe, )
   Re: partition question for new server setup  (Alan Hodgson, )
 Re: partition question for new server setup  (Craig James, )
  Re: partition question for new server setup  (Scott Carey, )
   Re: partition question for new server setup  (Whit Armstrong, )
    Re: partition question for new server setup  (Scott Carey, )
     Re: partition question for new server setup  (Whit Armstrong, )
   Re: partition question for new server setup  (Scott Marlowe, )
 Re: partition question for new server setup  (Scott Carey, )
  Re: partition question for new server setup  (Whit Armstrong, ) 
Craig James <> wrote:

> After a reading various articles, I thought that "noop" was the
> right choice when you're using a battery-backed RAID controller.
> The RAID controller is going to cache all data and reschedule the
> writes anyway, so the kernal schedule is irrelevant at best, and can
> slow things down.

Wouldn't that depend on the relative sizes of those caches?  In a
not-so-hypothetical example, we have machines with 120 GB OS cache,
and 256 MB BBU RAID controller cache.  We seem to benefit from
elevator=deadline at the OS level.

-Kevin

pgsql-performance by date:

Previous:
From: Scott Marlowe
Date:
Subject: Re: partition question for new server setup
Next:
From: Scott Carey
Date:
Subject: Re: partition question for new server setup