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

Might I suggest a change in the name of this thread or starting a new one.
The subject problem was resolved sometime ago and this is just bad publicity.
Almost scare me off till I read the user with the problem was now happy.

Bill Barnes

>===== Original Message From Bruce Momjian <pgman@candle.pha.pa.us> =====
>> 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.
>
>Yes, read my later posting describing the actual algorithm.  Let me know
>if it is wrong.
>
>--
>  Bruce Momjian                        |  http://www.op.net/~candle
>  pgman@candle.pha.pa.us               |  (610) 853-3000
>  +  If your life is a hard drive,     |  830 Blythe Avenue
>  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

------------------------------------------------------------
This e-mail has been sent to  you  courtesy of OperaMail,  a
free  web-based  service  from  Opera  Software,  makers  of
the award-winning Web Browser - http://www.operasoftware.com
------------------------------------------------------------