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

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 (view raw or flat)
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

pgsql-performance by date

Next:From: davidDate: 2009-01-25 13:16:40
Subject: Re: SSD performance
Previous:From: Scott MarloweDate: 2009-01-25 09:58:09
Subject: Re: strange index performance?

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