I want to install PostgreSQL 9.x version in an Ubuntu 14.04 workstation and I'm looking for a recommendation on how to set it up in order to
get a good read-write (50/50-balance) performance
keep a decent performance for overall conventional system usage.
My idea is to have two main partitions in an SSD drive:
[A] an ext4 for the root system ("/") with OS recommended/default settings.
[B] an ext4 for postgres database files ("/var/lib/pgsql") with a large block size (eg. 1MB) and a large readahead size (how much?) and proper flags (which?).
I have no clue whether separating postgres db files from general system is a good idea. In such a case, any piece of advice on [B] block size, readahead size, filesystem flags?
Furthermore any helpful hint?