Re: Updated ALTER TABLE ... SET TABLESPACE patch

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Updated ALTER TABLE ... SET TABLESPACE patch
Дата
Msg-id 3944.1089600846@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Updated ALTER TABLE ... SET TABLESPACE patch  (Gavin Sherry <swm@linuxworld.com.au>)
Список pgsql-patches
Gavin Sherry <swm@linuxworld.com.au> writes:
> On Mon, 12 Jul 2004, Christopher Kings-Lynne wrote:
>> I vote for taking it out.

> Pull it.  I added it intentionally but now I'm questioning my reasoning
> (which was, sequences might be accessed lots, people might want to put
> them somewhere intentionally).

I thought about that, but AFAICS a heavily used sequence would merely
end up as a single hot entry in the shared buffer arena (or at worst,
an often-hit page in kernel buffers).  It could not result in a lot of
actual I/O because it's only one page; at most one would expect one
write per checkpoint cycle.  So putting it on particularly fast disk
would be a useless exercise.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Updated ALTER TABLE ... SET TABLESPACE patch
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Updated ALTER TABLE ... SET TABLESPACE patch