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

From Mark Morgan Lloyd
Subject Re: [GENERAL] PostgreSQL on eMMC - Corrupt file system
Date
Msg-id o7jst3$p0n$1@pye-srv-01.telemetry.co.uk
Whole thread Raw
In response to Re: [GENERAL] PostgreSQL on eMMC - Corrupt file system  (Christoph Moench-Tegeder <cmt@burggraben.net>)
Responses Re: [GENERAL] PostgreSQL on eMMC - Corrupt file system  (Thomas Güttler <guettliml@thomas-guettler.de>)
List pgsql-general
On 09/02/17 23:00, Christoph Moench-Tegeder wrote:
> ## 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).

I agree, but three additional comments. First, we've got a fair number
of RPis running their root filesystems on the internal SD-Card without
problems, but the one Odroid which runs an eMMC card failed a few weeks
ago. Second, a useful precaution is to put stuff which will be updated
on an external device, although the same longevity concerns apply if
it's Flash-based. Third, experience here suggests that reliability
/might/ be improved if you fully zero a device before partitioning it to
make absolutely sure that the internal controller has touched every block.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]


pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: Re: [GENERAL] Locks Postgres
Next
From: Jehan-Guillaume de Rorthais
Date:
Subject: Re: [GENERAL] clarification about standby promotion