Re: [GENERAL] PG backup performance

2010-05-31 Thread Andy Colson
On 05/31/2010 02:45 PM, Isabella Ghiurea wrote: > I 'm looking for some tip, advice to improve PG backups performance, Yep, I thought I recalled a conversation like this before, this might have some interesting info: http://archives.postgresql.org/pgsql-performance/2010-03/msg00132.php

Re: [GENERAL] PG backup performance

2010-05-31 Thread Andy Colson
On 05/31/2010 02:45 PM, Isabella Ghiurea wrote: Hi Andy, Thank you , please, see bellow my answers: Andy Colson wrote: 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 compres

Re: [GENERAL] PG backup performance

2010-05-31 Thread Isabella Ghiurea
Hi Andy, Thank you , please, see bellow my answers: Andy Colson wrote: 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 writ

Re: [GENERAL] PG backup performance

2010-05-31 Thread Andy Colson
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 impro

[GENERAL] PG backup performance

2010-05-31 Thread Isabella Ghiurea
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 hardwar