Re: Partitioning Vs. Split Databases - performance? - Mailing list pgsql-general

From Ron Johnson
Subject Re: Partitioning Vs. Split Databases - performance?
Date
Msg-id 458B9504.7090702@cox.net
Whole thread Raw
In response to Re: Partitioning Vs. Split Databases - performance?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 12/22/06 01:22, Tom Lane wrote:
> Ron Johnson <ron.l.johnson@cox.net> writes:
>> Besides, since pg_dump is single-threaded, backing up a huge
>> database gets impossible.  Federating the database allows multiple
>> pg_dumps to simultaneously dump data to multiple tape drives.
>
> ... as long as you don't care about having a self-consistent dump ...

Nothing's perfect.

A pg_backup that writes multiple simultaneous data streams that are,
when taken as a unit, self-consistent would be tres' useful for Very
Large databases.

- --
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.6 (GNU/Linux)

iD8DBQFFi5UES9HxQb37XmcRAsinAJ0dkMdqdg3ROr9Jmpv6mtmhXaZubwCgi3PK
SfisJNzbFz/N5wR92tslHQ0=
=goE1
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: "Wong Jowo"
Date:
Subject: Re: Need help on "org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command"
Next
From: Rafal Pietrak
Date:
Subject: Re: Password strength requirements