Re: parallel restore

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: parallel restore
Date: 2009-01-06 22:54:34
Message-ID: 4963E12A.6010200@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jaime Casanova wrote:
> On Mon, Dec 29, 2008 at 6:42 PM, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
>
>> Attached is the latest parallel restore patch. I think this is getting
>> fairly close.
>>
>>
>
> mmm... seems this patch are two in one... you're adding --multi-thread
> and --truncate-before-load options where the second one seems to be an
> optimization...
>
> maybe it's better to split in two incremental patches?
>
>

Well, the only reason it was needed was because you can't run a parallel
restore in a single transaction. If the whole restore is run in a single
transaction then truncate before load should be unnecessary.

But if people want it made more general I can split it out.

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2009-01-06 23:01:22 Re: [COMMITTERS] pgsql: This makes all the \dX commands (most importantly to most: \df)
Previous Message Jaime Casanova 2009-01-06 22:48:15 Re: parallel restore