Re: PostgreSQL on eMMC - Corrupt file system

From: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL on eMMC - Corrupt file system
Date: 2017-02-09 22:58:17
Message-ID: 20170209225816.GB1556@elch.exwg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

## Thomas Güttler (guettliml(at)thomas-guettler(dot)de):

> Is running linux with postgres on eMMC a bad idea in general?

I'd say that running anything with a read-write load on eMMC will
end in pieces. It's ok to occasionally write something, but a mixed
load is not really what these things were designed for. The wear
leveling can be quite basic, you never know when it's gonna happen
(i.e. sudden power down can kill your filesystem - that's why disabling
journaling is not a very great idea), and if your device is "mostly
full" anyways, the wear leveling has not much space to redirect the
writes to. Remember that some of those chips are sold mostly by
price - that is, the hobbyist "embedded" devices get the cheapest
chips. A safer bet would be adding an external storage; some
64GB SATA SSDs are available for less than 50€ (perhaps it's better
not to go for the cheapest ones here, too).

Regards,
Christoph

--
Spare Space

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Venkata B Nagothi 2017-02-10 03:31:24 Re: clarification about standby promotion
Previous Message Joshua Chamberlain 2017-02-09 21:56:33 CREATE TABLE with parallel workers, 10.0?