Re: COPY FREEZE and PD_ALL_VISIBLE

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: COPY FREEZE and PD_ALL_VISIBLE
Дата
Msg-id CA+Tgmobg152avMQLXQQ7dWbhFK6sgyfuff_cNzz8WoKaZJqy2g@mail.gmail.com
обсуждение исходный текст
Ответ на COPY FREEZE and PD_ALL_VISIBLE  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: COPY FREEZE and PD_ALL_VISIBLE  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
On Sun, Oct 18, 2015 at 5:23 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
> I'm planning on adding a todo item to have COPY FREEZE set PD_ALL_VISIBLE.
> Or is there some reason this can't be done?
>
> Since the whole point of COPY FREEZE is to avoid needing to rewrite the
> entire table, it seems rather perverse that the first time the table is
> vacuumed, it needs to rewrite the entire table.

*facepalm*

I don't know how hard that is to implement, but +1 for trying to
figure out a way.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Allow ssl_renegotiation_limit in PG 9.5
Следующее
От: rajan
Дата:
Сообщение: Re: SuperUser check in pg_stat_statements