RE: PG 7.0 is 2.5 times slower running a big report - Mailing list pgsql-general

From Bill Barnes
Subject RE: PG 7.0 is 2.5 times slower running a big report
Date
Msg-id 395D342A@operamail.com
Whole thread Raw
In response to PG 7.0 is 2.5 times slower running a big report  ("Bryan White" <bryan@arcamax.com>)
List pgsql-general
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
------------------------------------------------------------


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: createdb -- alternate locations
Next
From: Tom Lane
Date:
Subject: Re: Speed of locating tables?