From: Scott Marlowe <scott.marlowe@gmail.com>
To: Campbell, Lance <lance@uiuc.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: Backup causing poor performance - suggestions
Date: Mon, 5 May 2008 13:44:16 -0600
Message-ID: <dcc563d10805051244q6cd3e778ub9e00d04af6d9f30@mail.gmail.com> (raw)
In-Reply-To: <B10E6810AC2A2F4EA7550D072CDE8760CDDD31@SAB-FENWICK.sab.uiuc.edu>
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>
On Mon, May 5, 2008 at 11:19 AM, Campbell, Lance <lance@uiuc.edu> wrote:
> Scott,
> When I do a df -h I see that the database takes up a total of 8Gig of
> disk space. This is not the size of the backup file of the database.
Ok. Just wanted to make sure. Looking at vmstat, with little or no
blocks read in, it would appear your database fits in memory.
> I have attached the vmstats as a text file. Are there any properties I
> could adjust that would help with writing data during a backup? Are
> there any properties that might help with improving pg_dump performance?
With as much writing as you have going on, it might help to crank up
your setting for checkpoint segments to something like 100 or more.
With as much disk space as you've got you can afford it. 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.
> Ideally I want to keep the backups as simple a process as possible
> before we have to go to the next level of backup. My next strategy is
> to put some of the tables in tablespaces on a couple different disks. I
> will also backup to a dedicated set of disks. If there are a few
> performance tweaks I can make I will. I was hoping to wait a few years
> before we have to go to a more involved backup process.
It may well be cheaper to go the route of a faster RAID controller
with battery backed cache, since it's a one time investment, not an
ongoing maintenance issue like running PITR or slony can become. Plus
it helps overall performance quite a bit.
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: scott.marlowe@gmail.com, lance@uiuc.edu
Subject: Re: Backup causing poor performance - suggestions
In-Reply-To: <dcc563d10805051244q6cd3e778ub9e00d04af6d9f30@mail.gmail.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