pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <gsmith@gregsmith.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Campbell, Lance <lance@uiuc.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: Backup causing poor performance - suggestions
Date: Mon, 5 May 2008 16:11:27 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0805051607160.28846@westnet.com> (raw)
In-Reply-To: <dcc563d10805051244q6cd3e778ub9e00d04af6d9f30@mail.gmail.com>
References: <B10E6810AC2A2F4EA7550D072CDE8760CDDD2C@SAB-FENWICK.sab.uiuc.edu>
	<dcc563d10805050805t197e9c02ue1a5b09144c6a8f7@mail.gmail.com>
	<B10E6810AC2A2F4EA7550D072CDE8760CDDD2D@SAB-FENWICK.sab.uiuc.edu>
	<dcc563d10805050854k676d1288kc637612b02426b3d@mail.gmail.com>
	<B10E6810AC2A2F4EA7550D072CDE8760CDDD30@SAB-FENWICK.sab.uiuc.edu>
	<dcc563d10805051005w568294efkc351c1390a227f1a@mail.gmail.com>
	<B10E6810AC2A2F4EA7550D072CDE8760CDDD31@SAB-FENWICK.sab.uiuc.edu>
	<dcc563d10805051244q6cd3e778ub9e00d04af6d9f30@mail.gmail.com>

On Mon, 5 May 2008, Scott Marlowe wrote:

> Other than that, you might wanna look at a faster / better RAID 
> controller in the future.  One with lots of battery backed cache set to 
> write back.

Hopefully Lance's PERC 6/I SAS already has its battery installed.  The 6/I 
with 256MB of cache is decent enough that I'm not sure getting a better 
controller would be a better investment than, say, adding more disks and 
splitting the database I/O usefully among them.

Upgrading to PG 8.3 comes to mind as another option I'd consider before 
getting desparate enough to add/swap controller cards, which is always a 
scary thing on production servers.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD



view thread (11+ messages)  latest in thread

Message-ID: <Pine.GSO.4.64.0805051607160.28846@westnet.com>
Permalink:  ../Pine.GSO.4.64.0805051607160.28846@westnet.com/
Also on:    postgresql.org/message-id/Pine.GSO.4.64.0805051607160.28846@westnet.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gsmith@gregsmith.com, scott.marlowe@gmail.com, lance@uiuc.edu
  Subject: Re: Backup causing poor performance - suggestions
  In-Reply-To: <Pine.GSO.4.64.0805051607160.28846@westnet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox