Backup causing poor performance - suggestions

From: "Campbell, Lance" <lance(at)uiuc(dot)edu>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Backup causing poor performance - suggestions
Date: 2008-05-05 14:59:57
Message-ID: B10E6810AC2A2F4EA7550D072CDE8760CDDD2C@SAB-FENWICK.sab.uiuc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

PostgreSQL: 8.2.4

We currently backup all of our database tables per schema using pg_dump
every half hour. We have been noticing that the database performance
has been very poor during the backup process. How can I improve the
performance?

Server Specs:

Dedicated DB server

Database takes up 8.0 Gig of disk space

2 Xeon 5160 dual cores 3.0

16 G of memory

Two disks in raid 1 are used for the OS, database and backups. SAS
10,000 RPM drives.

OS: Linux AS 4.x 64 bit

shared_buffers = 1 GB

work_mem = 20MB

max_fsm_pages = 524288

random_page_cost=1.0

effective_cache_size=16GB

max_connections=150

All other settings are the default settings.

I have tried doing backups to a second set of disks but the performance
only improved somewhat.

Does anyone have advice on how to improve my performance during backup?
Would adding two quad core processors improve performance?

Thanks,

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-05-05 15:05:32 Re: Backup causing poor performance - suggestions
Previous Message Mario Weilguni 2008-05-05 11:30:28 Re: Very slow INFORMATION_SCHEMA