Re: PostgreSQL on tablet grade SSD ? - Mailing list pgsql-general

From Merlin Moncure
Subject Re: PostgreSQL on tablet grade SSD ?
Date
Msg-id CAHyXU0yL23LT_J4HxkqRt+r+Uq=6MfNK9K2nM+N5+7OxB4JC2w@mail.gmail.com
Whole thread Raw
In response to PostgreSQL on tablet grade SSD ?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: PostgreSQL on tablet grade SSD ?  (David Boreham <david_list@boreham.org>)
List pgsql-general
On Thu, Oct 30, 2014 at 4:30 AM, Karsten Hilbert
<Karsten.Hilbert@gmx.net> wrote:
> Hi !
>
> Can anyone share any experiences with running PostgreSQL on a
> tablet ?  (Surface Pro 3, ASUS Transformer)
>
> (or point to things I should read, searching the web didn't
>  turn up anything that seemed relevant to *tablets*)

I can't speak to tablets specifically.  But there is danger running
postgres on 'cheap' SSD: they are not designed to accommodate a lot of
write activity.  This means you typically have some or all of the
following issues:

*) non durable writes
*) extremely slow fsync times
*) very rapid media wear

I would probably want to mount the database volume on external storage.

merlin


pgsql-general by date:

Previous
From: Torsten Förtsch
Date:
Subject: Re: Planet Postgres
Next
From: David Boreham
Date:
Subject: Re: PostgreSQL on tablet grade SSD ?