Re: [ADMIN] Questions on pg_dump

2008-07-18 Thread Chris Hoover
We understand that. The question is why is an uncompressed Fc format so much larger than a straight dump? Is the so bad it takes almost 5% extra space? On Fri, Jul 18, 2008 at 2:36 PM, Scott Mead <[EMAIL PROTECTED]> wrote: > Chris, > > Sorry I'm not responding to the list, I am not allowed to

[ADMIN] Questions on pg_dump

2008-07-18 Thread Chris Hoover
We are doing some additional testing of our backup strategy with the goal of moving from the text dump to the custom format and have some questions about pg_dump -Fc. Question 1. Why would the custom format be larger? pg_dump -Fc -Z 0 this morning was 88GB while the normal pg_dump last night was