Re: 8.3 / 8.2.6 restore comparison - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: 8.3 / 8.2.6 restore comparison
Date
Msg-id 20080225211857.0db12f74@jd-laptop
Whole thread Raw
In response to Re: 8.3 / 8.2.6 restore comparison  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: 8.3 / 8.2.6 restore comparison
List pgsql-hackers
On Mon, 25 Feb 2008 14:11:16 -0800
"Joshua D. Drake" <jd@commandprompt.com> wrote:

O.k. with 24 connections 3.5 hours. Testing with 12 now. 6 never
finished due to a bug.

Observations:

As simple as this solution is, it is not eloquent nor is it smart.
Using this method, if you have a 100GB table (which is very common)
you are still bound in a bad way by a single connection and you are
holding up everyone else.

Sincerely,

Joshua D. Drake

--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Link postgres from all object files at once, to avoid the
Next
From: Tom Lane
Date:
Subject: Re: pg_dump additional options for performance