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

From Alvaro Herrera
Subject Re: Practical maximums (was Re: PostgreSQL theoretical
Date
Msg-id 20060807214314.GC2666@alvh.no-ip.org
Whole thread Raw
In response to Re: Practical maximums (was Re: PostgreSQL theoretical  (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:

> This is where a multi-threaded pg_tapedump would be more effective,
> since it would be able to, for example, have 4 threads reading
> (different parts of) the database and writing to 4 separate tape drives.

It will be difficult to have a consistent dump though.  You can't do
that with separate transactions.  (And you can't have multiple
simultaneous readers without separate transactions.)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Practical maximums (was Re: PostgreSQL theoretical
Next
From: Scott Marlowe
Date:
Subject: Re: Practical maximums (was Re: PostgreSQL theoretical