Re: SSD performance - Mailing list pgsql-performance

From Gregory Stark
Subject Re: SSD performance
Date
Msg-id 87eiyrlhvx.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: SSD performance  (david@lang.hm)
Responses Re: SSD performance
List pgsql-performance
david@lang.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!

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: strange index performance?
Next
From: david@lang.hm
Date:
Subject: Re: SSD performance