Re: Practical maximums (was Re: PostgreSQL theoretical maximums.)

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Practical maximums (was Re: PostgreSQL theoretical maximums.)
Дата
Msg-id 200607310837.06729.peter_e@gmx.net
обсуждение исходный текст
Ответ на Practical maximums (was Re: PostgreSQL theoretical maximums.)  (Ron Johnson <ron.l.johnson@cox.net>)
Ответы Re: Practical maximums (was Re: PostgreSQL theoretical
Список pgsql-general
Ron Johnson wrote:
> I think I've read that there are multi-hundred GB PostgreSQL
> databases.
>
> Since pg_dump is single-threaded, how long does it take to back up
> such a database?

The evasive answer is that you probably don't run regular full pg_dump
on such databases.

> Are there any plans of making a multi-threaded, or even
> multi-process pg_dump?

What do you hope to accomplish by that?  pg_dump is not CPU bound.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

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

Предыдущее
От: gene Campbell
Дата:
Сообщение: Re: Secure connections with changing ip addresses?
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: use of index