CTED]
Sent: Mon 4/14/2008 7:58 PM
To: Phillip Smith
Cc: Ryan Wells; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Slow pg_dump
"Phillip Smith" <[EMAIL PROTECTED]> writes:
>> Here's my interpretation of those results: the TOAST tables for
>> our image f
"Phillip Smith" <[EMAIL PROTECTED]> writes:
>> Here's my interpretation of those results: the TOAST tables for
>> our image files are compressed by Postgres. During the backup,
>> pg_dump uncompresses them, and if compression is turned on,
>> recompresses the backup. Please correct me if I'm wron
ame
.
.
Hope this helps.
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of Ryan Wells
Sent: Sat 4/12/2008 5:59 PM
To: Ryan Wells; pgsql-admin@postgresql.org
Subject: [ADMIN] Slow pg_dump
We're having what seem like serious performance issues with
(Sorry, hit send too soon!)
> I ran pg_dump with the arguments you suggested, and my 4 GB test
> table finished backing up in about 25 minutes, which seems great.
> The only problem is that the resulting backup file was over 9 GB.
> Using -Z2 resulting in a 55 minute 6GB backup.
>
> Here's my int
Wells
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Slow pg_dump
"Ryan Wells" <[EMAIL PROTECTED]> writes:
> We have several tables that are used to store binary data as bytea (in
> this example image files),
Precompressed image formats, no doubt?
> pg_dump -i -h
om: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 12, 2008 9:46 PM
To: Ryan Wells
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Slow pg_dump
"Ryan Wells" <[EMAIL PROTECTED]> writes:
> We have several tables that are used to store binary data as bytea (in
>
"Ryan Wells" <[EMAIL PROTECTED]> writes:
> We have several tables that are used to store binary data as bytea (in
> this example image files),
Precompressed image formats, no doubt?
> pg_dump -i -h localhost -p 5432 -U postgres -F c -v -f "backupTest.backup" -t
> "public"."images" db_name
Try
We're having what seem like serious performance issues with pg_dump, and I hope
someone can help.
We have several tables that are used to store binary data as bytea (in this
example image files), but we're having similar time issues with text tables as
well.
In my most recent test, the samp
