Re: > 16TB worth of data question

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: > 16TB worth of data question
Дата
Msg-id 20030429160540.P66185@flake.decibel.org
обсуждение исходный текст
Ответ на Re: > 16TB worth of data question  (Ron Johnson <ron.l.johnson@cox.net>)
Ответы Re: > 16TB worth of data question
Список 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 по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Performance problems
Следующее
От: Mark Tessier
Дата:
Сообщение: Re: Bad timestamp external representation