I don't think that it makes sense to look at PG tuning and server
tuning as two separate tasks. XFS was recently benchmarked using
bonnie++ by Greg Smith, with interesting results:
That said, my guess is that the majority of large Linux installations
are using ext3 or ext4. It isn't the case that there's a favoured
filesystem for Postgres.
The kernel parameters that you'll want to change are sysV IPC parameters:
If you want a guide to choosing hardware for Postgres, I can highly
recommend Greg Smith's new book, "Postgresql 9 High performance".
In response to
pgsql-general by date
|Next:||From: Birta Levente||Date: 2011-01-06 13:58:13|
|Subject: pg_dump and database size question|
|Previous:||From: Sim Zacks||Date: 2011-01-06 11:20:54|
|Subject: linux server configuration|