Re: pgsql: Document random page cost is only 4x seqeuntial, and not 40x.
| От | Bruce Momjian |
|---|---|
| Тема | Re: pgsql: Document random page cost is only 4x seqeuntial, and not 40x. |
| Дата | |
| Msg-id | 20120214224618.GC3424@momjian.us обсуждение |
| Ответ на | Re: pgsql: Document random page cost is only 4x seqeuntial, and not 40x. (Thom Brown <thom@linux.com>) |
| Ответы |
Re: pgsql: Document random page cost is only 4x
seqeuntial, and not 40x.
|
| Список | pgsql-committers |
On Tue, Feb 14, 2012 at 10:44:08PM +0000, Thom Brown wrote: > On 14 February 2012 21:55, Bruce Momjian <bruce@momjian.us> wrote: > > Document random page cost is only 4x seqeuntial, and not 40x. > > > > Branch > > ------ > > master > > > > Details > > ------- > > http://git.postgresql.org/pg/commitdiff/c1d9df4fa227781b31be44a5a3024865a7f48049 > > > > Modified Files > > -------------- > > doc/src/sgml/config.sgml | 20 ++++++++++++++++++++ > > 1 files changed, 20 insertions(+), 0 deletions(-) > > This change does say that it is 40 times slower: > > "The default value can be thought of as modeling random access as 40 > times slower than sequential..." I meant to say that it documents why we have a default of 4x, not 40x. (In fact, real world, it is probably 100x.) -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +
В списке pgsql-committers по дате отправления: