From: Craig James <craig_james@emolecules.com>
To: justin <justin@emproshunts.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Need help with 8.4 Performance Testing
Date: Tue, 09 Dec 2008 17:56:57 -0800
Message-ID: <493F21E9.9010009@emolecules.com> (raw)
In-Reply-To: <493EFD07.4080201@emproshunts.com>
References: <C5642B9E.F8A%scott@richrelevance.com>
<22285.1228862315@sss.pgh.pa.us>
<493EFD07.4080201@emproshunts.com>
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, main memory, and persistent memory). The idea of external storage will probably disappear altogether -- computers will just have memory, and won't forget anything when you turn them off. Since most computers are 64 bits these days, all data and 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" memory and had to be connected by long wires, hence the need for I/O subsystems. As flash memory becomes mainstream, I expect this distinction to disappear.
Craig
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: craig_james@emolecules.com, justin@emproshunts.com
Subject: Re: Need help with 8.4 Performance Testing
In-Reply-To: <493F21E9.9010009@emolecules.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox