Re: gistchoose vs. bloat
| От | Alexander Korotkov |
|---|---|
| Тема | Re: gistchoose vs. bloat |
| Дата | |
| Msg-id | CAPpHfdsBQ8O3pv5cvWFj8U5MEzF1xCdyRFgpY_VXgSGQOsfRww@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: gistchoose vs. bloat (Jeff Davis <pgsql@j-davis.com>) |
| Список | pgsql-hackers |
On Tue, Sep 11, 2012 at 10:35 AM, Jeff Davis <pgsql@j-davis.com> wrote:
------
With best regards,
Alexander Korotkov.
On Tue, 2012-09-04 at 19:21 +0400, Alexander Korotkov wrote:Do you expect it to be bad in any reasonable situations? I'm inclined to
> New version of patch is attached. Parameter "randomization" was
> introduced. It controls whether to randomize choose. Choose algorithm
> was rewritten.
>
just make it always randomize if it's better. I think it would be hard
for a user to guess when it's better and when not.
Randomization should increase IO when index doesn't entirely fit to cache. Without randomization only fraction of the tree would be used for actual insertions. While with randomization whole tree would be potentially used for insertions.
Maybe it's useful to turn randomization off for testing purposes, e.g.
to ensure determinism?
Yes, that's another good point. For example, randomization impede reproducing of bugs.
With best regards,
Alexander Korotkov.
В списке pgsql-hackers по дате отправления: