Re: Partitioning Vs. Split Databases - performance?
От | Ron Johnson |
---|---|
Тема | Re: Partitioning Vs. Split Databases - performance? |
Дата | |
Msg-id | 458B9504.7090702@cox.net обсуждение исходный текст |
Ответ на | Re: Partitioning Vs. Split Databases - performance? (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | 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 по дате отправления: