Re: An idea for parallelizing COPY within one backend - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: An idea for parallelizing COPY within one backend
Date
Msg-id 20080227151002.GE5694@alvh.no-ip.org
Whole thread Raw
In response to Re: An idea for parallelizing COPY within one backend  ("A.M." <agentm@themactionfaction.com>)
Responses Re: An idea for parallelizing COPY within one backend  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
A.M. wrote:
>
> On Feb 27, 2008, at 9:11 AM, Florian G. Pflug wrote:

>> The reason that I'd love some within-one-backend solution is that I'd 
>> allow you to utilize more than one CPU for a restore within a *single* 
>> transaction. This is something that a client-side solution won't be 
>> able to deliver, unless major changes to the architecture of postgres 
>> happen first...
>
> It seems like multiple backends should be able to take advantage of 2PC 
> for transaction safety.

Yeah, but it wouldn't take advantage of, say, the hack to disable WAL
when the table was created in the same transaction.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Brian Hurt
Date:
Subject: Re: An idea for parallelizing COPY within one backend
Next
From: Tom Lane
Date:
Subject: Re: Proposal: wildcards in pg_service.conf