| 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: | Whole Thread | Raw Message | 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
| 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 |