Re: Troubles dumping a very large table.

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: Troubles dumping a very large table.
Дата
Msg-id 200812291348.39979.dfontaine@hi-media.com
обсуждение исходный текст
Ответ на Re: Troubles dumping a very large table.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Gregory Williamson"
Дата:
Сообщение: Re: Slow table update
Следующее
От: Laszlo Nagy
Дата:
Сообщение: Re: Slow table update - SOLVED!