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
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 |