Re: Need help with 8.4 Performance Testing - Mailing list pgsql-performance

From Craig James
Subject Re: Need help with 8.4 Performance Testing
Date
Msg-id 493F21E9.9010009@emolecules.com
Whole thread Raw
In response to Re: Need help with 8.4 Performance Testing  (justin <justin@emproshunts.com>)
List pgsql-performance
justin wrote:
> Tom Lane wrote:
>> Hmm ... I wonder whether this means that the current work on
>> parallelizing I/O (the posix_fadvise patch in particular) is a dead
>> end.  Because what that is basically going to do is expend more CPU
>> to improve I/O efficiency.  If you believe this thesis then that's
>> not the road we want to go down.
>>
>>             regards, tom lane
>>
> What does the CPU/ Memory/Bus performance road map look like?
>
> Is the IO performance for storage device for what ever it be, going to
> be on par with the above to cause this problem?

Flash memory will become just a fourth layer in the memory caching system (on-board CPU, high-speed secondary cache,
mainmemory, and persistent memory).  The idea of external storage will probably disappear altogether -- computers will
justhave memory, and won't forget anything when you turn them off.  Since most computers are 64 bits these days, all
dataand programs will just hang out in memory at all times, and be directly addressable by the CPU. 

The distinction between disk and memory arose from the fact that disks were large, slow devices relative to "core"
memoryand had to be connected by long wires, hence the need for I/O subsystems.  As flash memory becomes mainstream, I
expectthis distinction to disappear. 

Craig

pgsql-performance by date:

Previous
From: Ron Mayer
Date:
Subject: Re: Need help with 8.4 Performance Testing
Next
From: "Robert Haas"
Date:
Subject: Re: Need help with 8.4 Performance Testing