Re: pg_dump additional options for performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump additional options for performance
Дата
Msg-id 5327.1204048937@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump additional options for performance  (Greg Smith <gsmith@gregsmith.com>)
Ответы Re: pg_dump additional options for performance  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-hackers
Greg Smith <gsmith@gregsmith.com> writes:
> While the pg_dump split train seems to be leaving the station, I feel 
> compelled to point out that focus does nothing to help people who are 
> bulk-loading data that came from somewhere else.

What are you imagining here ... a plain SQL script containing
database-independent INSERT commands?  That's going to suck compared
to COPY no matter what.

If you're imagining that it's at least pg_dump output that came from
someplace else, we can probably speed it up using the ideas being
kicked around here.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Idle idea for improving concurrency of LISTEN/NOTIFY
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: pg_dump additional options for performance