Re: Troubles dumping a very large table. - Mailing list pgsql-performance

From Dimitri Fontaine
Subject Re: Troubles dumping a very large table.
Date
Msg-id 200812291348.39979.dfontaine@hi-media.com
Whole thread Raw
In response to Re: Troubles dumping a very large table.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Hi,

Le vendredi 26 décembre 2008, Tom Lane a écrit :
> Yeah, if he's willing to use COPY BINARY directly.  AFAIR there is not
> an option to get pg_dump to use it.

Would it be possible to consider such an additional switch to pg_dump?

Of course the DBA has to know when to use it safely, but if the plan is to be
able to restore later dump on the same machine to recover from some human
error (oops, forgot the WHERE clause to this DELETE statement), it seems it
would be a good idea.

Regards,
--
dim

Attachment

pgsql-performance by date:

Previous
From: "Gregory Williamson"
Date:
Subject: Re: Slow table update
Next
From: Laszlo Nagy
Date:
Subject: Re: Slow table update - SOLVED!