Re: Remove xmin and cmin from frozen tuples

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Remove xmin and cmin from frozen tuples
Дата
Msg-id 200509021939.j82Jd9g29228@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Remove xmin and cmin from frozen tuples  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Remove xmin and cmin from frozen tuples  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> Of course, it's fair to ask whether such a program would be any faster
> than binary-mode COPY by the time you got done ... or enough faster to
> justify your effort, anyway.
> 
> THe only fundamental disadvantage that COPY labors under is having to
> write WAL records.  It might be interesting to do something similar to
> the recent hacks for CREATE TABLE AS, so that a COPY into a table just
> created in the current transaction would skip writing WAL and instead
> fsync the table at the end.

Added to TODO:
       o Allow COPY into an empty table to skip WAL logging

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Mark Wong
Дата:
Сообщение: Re: dbt-4 (tpc-app) kit
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: dbt-4 (tpc-app) kit