Re: Minmax indexes

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: Minmax indexes
Дата
Msg-id CAGTBQpaRMj=a4z3-5HJdVstdShEU5RxLrkDsab46dyqOQYSYtA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Minmax indexes  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: Minmax indexes  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
On Wed, Jul 9, 2014 at 6:16 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> Another thing I noticed is that version 8 of the patch blindly believed
> the "pages_per_range" declared in catalogs.  This meant that if somebody
> did "alter index foo set pages_per_range=123" the index would
> immediately break (i.e. return corrupted results when queried).  I have
> fixed this by storing the pages_per_range value used to construct the
> index in the metapage.  Now if you do the ALTER INDEX thing, the new
> value is only used when the index is recreated by REINDEX.

This seems a lot like parameterizing. So I guess the only thing left
is to issue a NOTICE when said alter takes place (I don't see that on
the patch, but maybe it's there?)



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: pgindent weirdness
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pgindent weirdness