Re: Slow pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ryan Wells" <ryan(dot)wells(at)soapware(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Slow pg_dump
Date: 2008-04-13 02:46:06
Message-ID: 14644.1208054766@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Ryan Wells" <ryan(dot)wells(at)soapware(dot)com> 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 it with -Z0, or even drop the -Fc completely, since it's certainly
not very helpful on a single-table dump. Re-compressing already
compressed data is not only useless but impressively slow ...

Also, drop the -i, that's nothing but a foot-gun.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Darren Reed 2008-04-14 05:52:08 postgres 8.2.6 core dump when initialising.
Previous Message Ryan Wells 2008-04-13 00:59:09 Slow pg_dump