Re: Partitioning Vs. Split Databases - performance?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Partitioning Vs. Split Databases - performance?
Date: 2006-12-22 07:22:32
Message-ID: 21158.1166772152@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wong Jowo 2006-12-22 08:07:17 Re: Need help on "org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command"
Previous Message Bruno Wolff III 2006-12-22 07:20:06 Re: Password strength requirements