Re: Table clustering idea

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Table clustering idea
Дата
Msg-id 200606272046.40473.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Table clustering idea  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-hackers
Jim,

> I know there were discussions in the past, though as per usual I can't
> find them in the archives.

Search on "B-Tree Organized Tables".

From what I can find, this feature isn't prohibitively useless.  It's just a
singnificant amount of effort for a result which is a tradeoff.   That is,
you'd *only* want to use it on tables which are *always* accessed by their
primary key.

What stopped the features AFAICT is that the interested parties weren't up to
doing the code.

--
Josh Berkus
PostgreSQL @ Sun
San Francisco


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

Предыдущее
От: "tju tju"
Дата:
Сообщение:
Следующее
От: Josh Berkus
Дата:
Сообщение: Page format changes for 8.2?