Re: Minor TODO list changes
От | Simon Riggs |
---|---|
Тема | Re: Minor TODO list changes |
Дата | |
Msg-id | 1099588442.4320.518.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Minor TODO list changes (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: Minor TODO list changes
|
Список | pgsql-hackers |
On Thu, 2004-11-04 at 16:51, Bruce Momjian wrote: > OK, I updated all your items. Thanks > I removed fillfactor because I thought I > was the only one who thought it was valuable and as I remember it was > mostly useful for ISAM, which we don't support. Can you think of a use > for a non-100% fillfactor? > I was under the impression the factor was 67% for data loaded on the leading-edge of an index, and 50% for other INSERTs. (backend/access/nbtree/nbtinsert.c) Not sure, without checking, what CREATE INDEX and COPY do, but I'm guessing it is similar? Other RDBMS use a higher leading-edge/standard fill factor. There are situations where I'd want to set it at 90%, or even 100%. If I know the update rate is likely to be zero, then I'd like my indexes to fit in 10-30% less memory and disk, please. Or am I missing something? -- Best Regards, Simon Riggs
В списке pgsql-hackers по дате отправления: