Re: An idea for parallelizing COPY within one backend

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: An idea for parallelizing COPY within one backend
Дата
Msg-id 20080227151002.GE5694@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: An idea for parallelizing COPY within one backend  ("A.M." <agentm@themactionfaction.com>)
Ответы Re: An idea for parallelizing COPY within one backend  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Brian Hurt
Дата:
Сообщение: Re: An idea for parallelizing COPY within one backend
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Proposal: wildcards in pg_service.conf