Re: > 16TB worth of data question - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: > 16TB worth of data question
Date
Msg-id 20030429160540.P66185@flake.decibel.org
Whole thread Raw
In response to Re: > 16TB worth of data question  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: > 16TB worth of data question  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
On Tue, Apr 29, 2003 at 01:01:39AM -0500, Ron Johnson wrote:
> But pg doesn't guarantee internal consistency unless you pg_dump
> the database in one command "pg_dump db_name > db_yyyymmdd.dmp".
>
> Thus, no parallelism unless there are multiple databases, but if there's
> only 1 database...

It would probably be useful if you could feed a specific transaction
id/timestamp to pg_dump, so that it will take the snapshot as of that
time. Of course, it'd probably be easiest if you could just tell pg_dump
to use X number of threads or dump devices.
--
Jim C. Nasby (aka Decibel!)                    jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"


pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Performance problems
Next
From: Mark Tessier
Date:
Subject: Re: Bad timestamp external representation