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

From Ron Johnson
Subject Re: Practical maximums (was Re: PostgreSQL theoretical
Date
Msg-id 44D7AC22.6020805@cox.net
Whole thread Raw
In response to Re: Practical maximums (was Re: PostgreSQL theoretical  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: Practical maximums (was Re: PostgreSQL theoretical  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Practical maximums (was Re: PostgreSQL theoretical  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Scott Marlowe wrote:
> On Mon, 2006-08-07 at 15:18, Ron Johnson wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> Scott Marlowe wrote:
>>> Oh, I see where you were headed.
>>>
>>> I've found a bit here and there googling about for multiplex and tar,
>>> and found an IO:Multiplex module for perl.
>>>
>>> I don't see why someone couldn't make use of it to create some kind of
>>> system where you'd do:
>>>
>>> pg_dump dbname | perl mulitiplexscript device1,device2,device3,devicen
>>>
>>> No need for postgresql to support it directly.  Restoring would likewise
>>> just be a reverse operation.
>> Interesting.  Many thanks.  Scary though that it hasn't been touched
>> in 30 months.
>>
>> With multiple SCSI cards, each with it's own tape drive, this
>> immensely speeds up the backup operation.
>
> Yeah, I read the description, and I think it's just a fancy name for
> tee.  sigh.  Not REAL multiplexing, but stream duplication.

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.

- --
Ron Johnson, Jr.
Jefferson LA  USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFE16wiS9HxQb37XmcRAvi0AJ0eHuurG7cC3HC9A1lOMXvcBDJ7QACeMlyB
bS3ozQ69gFgrM70oHGJr8Zk=
=8N8c
-----END PGP SIGNATURE-----

pgsql-general by date:

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