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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Subject: Re: Practical maximums (was Re: PostgreSQL theoretical maximums.)
Date: 2006-07-31 06:37:06
Message-ID: 200607310837.06729.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2006-07-31 06:47:17 Re: use of index
Previous Message gene Campbell 2006-07-31 06:35:36 Re: Secure connections with changing ip addresses?