Re: SSD performance

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: david(at)lang(dot)hm
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: SSD performance
Date: 2009-01-25 11:55:30
Message-ID: 87eiyrlhvx.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

david(at)lang(dot)hm writes:

> they currently have it do a backup immediatly on power loss (which is a safe
> choice as the contents won't be changing without power), but it then powers off
> (which is not good for startup time afterwords)

So if you have a situation where it's power cycling rapidly each iteration
drains the battery of the time it takes to save the state but only charges it
for the time the power is on. I wonder how many iterations that gives you.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony Replication support!

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message david 2009-01-25 13:16:40 Re: SSD performance
Previous Message Scott Marlowe 2009-01-25 09:58:09 Re: strange index performance?