Skip site navigation (1) Skip section navigation (2)

Re: High load,

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Michael Kohl <michael(dot)kohl(at)tupalo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: High load,
Date: 2011-01-27 17:54:22
Message-ID: 20110127175422.GB30352@tamriel.snowman.net (view raw or flat)
Thread:
Lists: pgsql-performance
* Michael Kohl (michael(dot)kohl(at)tupalo(dot)com) wrote:
> HDD: 2x 120 GB OCZ Vertex 2 SSD; RAID 1

I'm amazed no one else has mentioned this yet, but you should look into
splitting your data and your WALs.  Obviously, having another set of
SSDs to put your WALs on would be ideal.

You should probably also be looking into adjustments to the background
writer.  It sounds like you're getting hit by large checkpoint i/o
(if you turn on logging of that, as someone else suggested, you'll be
able to corrollate the times), which can be helped by increasing the
amount of writing done between checkpoints, so that the checkpoints
aren't as big and painful.  That can be done by making the background
writer more aggressive.

	Thanks,

		Stephen

In response to

  • High load, at 2011-01-27 10:31:13 from Michael Kohl

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2011-01-27 18:13:17
Subject: Re: High load,
Previous:From: Andy ColsonDate: 2011-01-27 17:20:18
Subject: Re: High load,

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group