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

Re: io storm on checkpoints, postgresql 8.2.4, linux

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Dmitry Potapov <fortune(dot)fish(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: io storm on checkpoints, postgresql 8.2.4, linux
Date: 2007-08-22 16:01:43
Message-ID: 46CC5DE7.9010201@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Dmitry Potapov wrote:
>             Hello!
> 
>     We run a large (~66Gb) web-backend database on Postgresql 8.2.4 on
> Linux. The hardware is  Dual Xeon 5130 with 16Gb ram, LSI Megaraid U320-2x
> scsi controller w/512Mb writeback cache and a BBU. Storage setup contains 3
> raid10 arrays (data, xlog, indexes, each on different array), 12 HDDs total.
> Frontend application uses jdbc driver, connection pooling and threads.
> 
>     We've run into an issue of IO storms on checkpoints. Once in 20min
> (which is checkpoint_interval) the database becomes unresponsive for about
> 4-8 seconds. Query processing is suspended, server does nothing but writing

What are your background writer settings?

Joshua D. Drake

- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
			UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGzF3nATb/zqfZUUQRAsV8AJ9Sg7yTUfTGKTB/vQdW5BucwgcRSgCeKqIE
jzR7X5+n0x1Y91etGOBvvpE=
=4Dc9
-----END PGP SIGNATURE-----

In response to

Responses

pgsql-performance by date

Next:From: Carlo StonebanksDate: 2007-08-22 16:02:54
Subject: Fast tsearch2, trigram matching on short phrases
Previous:From: Mark MielkeDate: 2007-08-22 15:57:33
Subject: Re: io storm on checkpoints, postgresql 8.2.4, linux

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