Re: Practical maximums (was Re: PostgreSQL theoretical maximums.) - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Practical maximums (was Re: PostgreSQL theoretical maximums.)
Date
Msg-id 200607310837.06729.peter_e@gmx.net
Whole thread Raw
In response to Practical maximums (was Re: PostgreSQL theoretical maximums.)  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: Practical maximums (was Re: PostgreSQL theoretical  (Ron Johnson <ron.l.johnson@cox.net>)
List 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 by date:

Previous
From: gene Campbell
Date:
Subject: Re: Secure connections with changing ip addresses?
Next
From: Michael Glaesemann
Date:
Subject: Re: use of index