Re: Index AM change proposals, redux

Поиск
Список
Период
Сортировка
От Ron Mayer
Тема Re: Index AM change proposals, redux
Дата
Msg-id 480FF3C3.4030802@cheapcomplexdevices.com
обсуждение исходный текст
Ответ на Re: Index AM change proposals, redux  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Index AM change proposals, redux  (Teodor Sigaev <teodor@sigaev.ru>)
Re: Index AM change proposals, redux  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
>> On Wed, 2008-04-23 at 12:07 -0400, Tom Lane wrote:
>>> To be acceptable, a GIT patch would have to be optional and it
>>> ...
> I was considering a new pg_index column.  Or else we'd have to fix
> the storage-parameter infrastructure to support restricting changes
> of some parameters.


Interesting.  Does this mean that down the road a postgis index
might be GIT-ified?

On my biggest tables (clustered by zip/postal code) the index on
the  geometry  column with a postgis index probably sees all the
rows on each  of it's pages pointing to the same few heap pages.
If I understand right, that's the kind of pattern that GIT helps.



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Index AM change proposals, redux
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Proposed patch - psql wraps at window width