Re: skip WAL on COPY patch

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: skip WAL on COPY patch
Дата
Msg-id 3073.1314130656@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: skip WAL on COPY patch  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: skip WAL on COPY patch  (Steve Singer <ssinger@ca.afilias.info>)
Re: skip WAL on COPY patch  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> What I think would be really interesting is a way to make this work
> when the table *isn't* empty.  In other words, have a COPY option that
> (1) takes an exclusive lock on the table, (2) writes the data being
> inserted into new pages beyond the old EOF, and (3) arranges for crash
> recovery or transaction abort to truncate the table back to its
> previous length.  Then you could do fast bulk loads even into a table
> that's already populated, so long as you don't mind that the table
> will be excusive-locked and freespace within existing heap pages won't
> be reused.

What are you going to do with the table's indexes?
        regards, tom lane


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

Предыдущее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Getting rid of pg_pltemplate
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: skip WAL on COPY patch