Re: Partitioning Vs. Split Databases - performance?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 12/22/06 01:22, Tom Lane wrote:
> Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)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-----