Skip site navigation (1) Skip section navigation (2)

Re: Need help with 8.4 Performance Testing

From: Craig James <craig_james(at)emolecules(dot)com>
To: justin <justin(at)emproshunts(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Need help with 8.4 Performance Testing
Date: 2008-12-10 01:56:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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, 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.


In response to

pgsql-performance by date

Next:From: Robert HaasDate: 2008-12-10 03:06:31
Subject: Re: Need help with 8.4 Performance Testing
Previous:From: Ron MayerDate: 2008-12-10 01:37:41
Subject: Re: Need help with 8.4 Performance Testing

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group