Re: What is the most optimal config parameters to keep stable write TPS ?..

From: Kevin Grittner
Subject: Re: What is the most optimal config parameters to keep stable write TPS ?..
Date: ,
Msg-id: 4A080FD6.EE98.0025.0@wicourts.gov
(view: Whole thread, Raw)
In response to: Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri)
Responses: Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri)
List: pgsql-performance

Tree view

What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri, )
 Re: What is the most optimal config parameters to keep stable write TPS ?..  ("Kevin Grittner", )
  Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri, )
   Re: What is the most optimal config parameters to keep stable write TPS ?..  ("Kevin Grittner", )
    Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri, )
     Re: What is the most optimal config parameters to keep stable write TPS ?..  ("Kevin Grittner", )
      Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri, )
   Re: What is the most optimal config parameters to keep stable write TPS ?..  (Scott Marlowe, )
    Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri, )
   Re: What is the most optimal config parameters to keep stable write TPS ?..  (Laurent Laborde, )
    Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri, )
   Re: What is the most optimal config parameters to keep stable write TPS ?..  ( (Julian v. Bock), )
    Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri, )
 Re: What is the most optimal config parameters to keep stable write TPS ?..  (Greg Smith, )
  Re: What is the most optimal config parameters to keep stable write TPS ?..  (Scott Marlowe, )

Dimitri <> wrote:

> PostgreSQL: 8.3.7 & 8.4
> Server: Sun M5000 32cores
> OS: Solaris 10

Does that have a battery backed RAID controller?  If so, is it
configured for write-back?  These both help a lot with smoothing
checkpoint I/O gluts.

We've minimized problems by making the background writer more
aggressive.  8.3 and later does a better job in general, but we've
still had to go with:

bgwriter_lru_maxpages = 1000
bgwriter_lru_multiplier = 4.0

> shared_buffers = 12000MB

You might want to test with that set to something much lower, to see
what the checkpoint delays look like.  We've found it best to use a
small (256MB) setting, and leave caching to the OS; in our
environment, it seems to do a better job of scheduling the disk I/O.
YMMV, of course.

-Kevin


pgsql-performance by date:

From: Dimitri
Date:
Subject: Re: Any better plan for this query?..
From: Dimitri
Date:
Subject: Re: Any better plan for this query?..