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
|
Список | 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 по дате отправления: