Re: bytea vs. pg_dump

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: bytea vs. pg_dump
Дата
Msg-id 15219.1241532037@sss.pgh.pa.us
обсуждение исходный текст
Ответ на bytea vs. pg_dump  (Bernd Helmle <mailings@oopsware.de>)
Ответы Re: bytea vs. pg_dump  (Dimitri Fontaine <dfontaine@hi-media.com>)
Re: bytea vs. pg_dump  (Bernd Helmle <mailings@oopsware.de>)
Список pgsql-hackers
Bernd Helmle <mailings@oopsware.de> writes:
> From time to time we had complains about slow dump of large tables with 
> bytea columns, people often complaining about a) size and b) duration of 
> the dump.

> That latter occurred recently to me, a customer would like to dump large 
> tables (approx. 12G in size) with pg_dump, but he was annoyed about the 
> performance. Using COPY BINARY reduced the time (unsurprisingly) to a 
> fraction (from 12 minutes to 3 minutes).

Seems like the right response might be some micro-optimization effort on
byteaout.
        regards, tom lane


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: conditional dropping of columns/constraints
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: bytea vs. pg_dump