Re: [HACKERS] Some notes on optimizer cost estimates

Поиск
Список
Период
Сортировка
От Don Baccus
Тема Re: [HACKERS] Some notes on optimizer cost estimates
Дата
Msg-id 3.0.1.32.20000124115531.01071320@mail.pacifier.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Some notes on optimizer cost estimates  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
At 01:13 PM 1/24/00 -0500, Tom Lane wrote:

>In practice this would be happening at initdb time, not configure time,
>since it'd be a lot easier to do it in C code than in a shell script.
>But that's a detail.  I'm still not clear on how you can wave away the
>issue of kernel disk caching --- if you don't use a test file that's
>larger than the disk cache, ISTM you risk getting a number that's
>entirely devoid of any physical I/O at all.

And even the $100 6.4 GB Ultra DMA drive I bought last week has
2MB of cache.  hdparm shows me getting 19 mB/second transfers
even though it adjusts for the file system cache.  It's only a
5400 RPM disk and I'm certain the on-disk cache is impacting
this number.



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.
 


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

Предыдущее
От: Don Baccus
Дата:
Сообщение: Re: [HACKERS] Well, then you keep your darn columns
Следующее
От: Don Baccus
Дата:
Сообщение: Re: [HACKERS] Well, then you keep your darn columns