Re: PG 7.0 is 2.5 times slower running a big report

Поиск
Список
Период
Сортировка
От Alfred Perlstein
Тема Re: PG 7.0 is 2.5 times slower running a big report
Дата
Msg-id 20000526034107.S28594@fw.wintelcom.net
обсуждение исходный текст
Ответ на Re: PG 7.0 is 2.5 times slower running a big report  ("Matthias Urlichs" <smurf@noris.de>)
Ответы Re: PG 7.0 is 2.5 times slower running a big report  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
* Matthias Urlichs <smurf@noris.de> [000526 02:47] wrote:
> Hi,
>
> Bruce Momjian:
> > As I remember, Linux turns off file system prefetch if a seek is done.
>
> Correct (still so for Linux 2.4).
>
> > BSD file systems turn off prefetch only if prefetched blocks remain
> > unused.
>
> "Unused" is decided when?
> Do any, all, or some percentage of prefetched blocks need to be unused?

The statement:

> > BSD file systems turn off prefetch only if prefetched blocks remain
> > unused.

is false for FreeBSD afaik.

FreeBSD tracks how often sequential access happens and will retry it
as the file's access trend indicates.  It can flip back and forth from
readahead and non-readahead.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

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

Предыдущее
От: Giles Lean
Дата:
Сообщение: Re: createdb -- alternate locations
Следующее
От: Bill Barnes
Дата:
Сообщение: Windoze port of version 7