| From: | Andy Colson <andy(at)squeakycode(dot)net> |
|---|---|
| To: | Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PG backup performance |
| Date: | 2010-05-31 19:13:05 |
| Message-ID: | 4C040A41.5020204@squeakycode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 05/31/2010 11:05 AM, Isabella Ghiurea wrote:
> Hello PG list,
> I 'm looking for some tip, advice toimprove PG backups performance,
> presently running
> pg_dumpall compressed option on raid array 0 getting aprox14GB writes in
> 45 min, I'm backing up aprox 200GB database cluster daily .
> How can I improve this performance with the present hardware and PG
> version 8.3.6 , can I run parallel backups in PG ?
> Thank you
> Isabella
>
Short answer, yes, you can.
Long answer, we need more info.
We need to know what the slow part is.
Are you CPU bound or IO bound?
Are you backing up over a network?
How many tables? (well, big tables... how many really big tables).
How many cores/cpu's do you have?
I bet all 200GB hardly changes, are you sure you need to back it all up over and over again? Have you thought of replication?
-Andy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Wilcox | 2010-05-31 19:14:34 | Re: Out of Memory and Configuration Problems (Big Computer) |
| Previous Message | Devrim Gündüz | 2010-05-31 18:49:42 | Re: What Linux edition we should chose? |