Re: [GENERAL] PostgreSQL on eMMC - Corrupt file system - Mailing list pgsql-general

From Christoph Moench-Tegeder
Subject Re: [GENERAL] PostgreSQL on eMMC - Corrupt file system
Date
Msg-id 20170209225816.GB1556@elch.exwg.net
Whole thread Raw
In response to Re: [GENERAL] PostgreSQL on eMMC - Corrupt file system  (Thomas Güttler <guettliml@thomas-guettler.de>)
Responses Re: [GENERAL] PostgreSQL on eMMC - Corrupt file system  (Mark Morgan Lloyd <markMLl.pgsql-general@telemetry.co.uk>)
List pgsql-general
## Thomas Güttler (guettliml@thomas-guettler.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


pgsql-general by date:

Previous
From: Joshua Chamberlain
Date:
Subject: [GENERAL] CREATE TABLE with parallel workers, 10.0?
Next
From: Venkata B Nagothi
Date:
Subject: Re: [GENERAL] clarification about standby promotion