Re: skip WAL on COPY patch

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: skip WAL on COPY patch
Дата
Msg-id 1739.1314126320@sss.pgh.pa.us
обсуждение исходный текст
Ответ на skip WAL on COPY patch  (Steve Singer <ssinger@ca.afilias.info>)
Ответы Re: skip WAL on COPY patch  (Robert Haas <robertmhaas@gmail.com>)
Re: skip WAL on COPY patch  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-hackers
Steve Singer <ssinger@ca.afilias.info> writes:
> The attached patch adds an option to the COPY command to skip writing 
> WAL when the following conditions are all met:

> 1) The table is empty (zero size on disk)
> 2) The copy command can obtain an access exclusive lock on the table 
> with out blocking.
> 3) The WAL isn't needed for replication

Exposing this as a user-visible option seems a seriously bad idea.
We'd have to support that forever.  ISTM it ought to be possible to
avoid the exclusive lock ... maybe not with this particular
implementation, but somehow.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: text search: restricting the number of parsed words in headline generation
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Getting rid of pg_pltemplate