Re: Slow pg_dump

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Slow pg_dump
Дата
Msg-id 14644.1208054766@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Slow pg_dump  ("Ryan Wells" <ryan.wells@soapware.com>)
Ответы Re: Slow pg_dump  ("Ryan Wells" <ryan.wells@soapware.com>)
Список pgsql-admin
"Ryan Wells" <ryan.wells@soapware.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

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

Предыдущее
От: "Ryan Wells"
Дата:
Сообщение: Slow pg_dump
Следующее
От: Darren Reed
Дата:
Сообщение: postgres 8.2.6 core dump when initialising.