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

Re: Making the most of memory?

From: "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Making the most of memory?
Date: 2008-01-23 20:40:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Jan 23, 2008, at 2:57 PM, Guy Rouillier wrote:

> Scott Marlowe wrote:
>> I assume you're talking about solid state drives?  They have their
>> uses, but for most use cases, having plenty of RAM in your server  
>> will
>> be a better way to spend your money.  For certain high throughput,
>> relatively small databases (i.e. transactional work) the SSD can be
>> quite useful.
> Unless somebody has changes some physics recently, I'm not  
> understanding the recent discussions of SSD in the general press.   
> Flash has a limited number of writes before it becomes unreliable.   
> On good quality consumer grade, that's about 300,000 writes, while  
> on industrial grade it's about 10 times that.  That's fine for mp3  
> players and cameras; even professional photographers probably won't  
> rewrite the same spot on a flash card that many times in a  
> lifetime.  But for database applications, 300,000 writes is  
> trivial. 3 million will go a lot longer, but in non-archival  
> applications, I imagine even that mark won't take but a year or two  
> to surpass.

Please let outdated numbers rest in peace.

"With current technologies write endurance is not a factor you should  
be worrying about when deploying flash SSDs for server acceleration  
applications - even in a university or other analytics intensive  
environment. "

That said, postgresql is likely making assumptions about non-volatile  
storage that will need to be shattered once SSDs become more widely  
deployed. Perhaps SSDs will replace RAID BBUs and then the HDs  


In response to

pgsql-performance by date

Next:From: Brian HurtDate: 2008-01-23 20:50:59
Subject: Re: Making the most of memory?
Previous:From: Tom LaneDate: 2008-01-23 20:25:50
Subject: Re: Vacuum and FSM page size

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