Re: Equivalent praxis to CLUSTERED INDEX?

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: Equivalent praxis to CLUSTERED INDEX?
Дата
Msg-id 41306EF3.2030304@bigfoot.com
обсуждение исходный текст
Ответ на Re: Equivalent praxis to CLUSTERED INDEX?  (Greg Stark <gsstark@mit.edu>)
Список pgsql-performance
Greg Stark wrote:

> Bruce Momjian <pgman@candle.pha.pa.us> writes:
>
>
>>>Don't you think this will permit also to avoid extra disk seek and cache
>>>invalidation? If you are updating the row (0,1) I think is less expensive
>>>put the new version in (0,2) instead of thousand line far from that point.
>
>
> Well if the other buffer "a thousand lines far from that point" is already in
> ram, then no, there's no penalty at the time for storing it there.

I was wandering about the cache invalidation, may be the ram is big enough but I
doubt about the cache, the recommendation in this case is to modify adjacent
memory address instead of jumping.


Regards
Gaetano Mendola



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

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: ill-planned queries inside a stored procedure
Следующее
От: andrew@pillette.com
Дата:
Сообщение: Re: ill-planned queries inside a stored procedure