Anton Melser wrote:
It's a website, with probably around 98% read to 2% write, and the
writes only to a few tables.
The machine is only doing this one DB, with the odd email being sent
by postfix (20 p/d, so nothing) and for the moment we aren't doing any
real logging apart from postgres internal (so not even activity logs
or query logs, etc).
So given that disk usage is pretty much 100% pgsql, and it's mainly
read, does my architecture stand up? And thanks, I'll have a read of
the tablespaces chapter - I looked pretty much everywhere but there!
With a small number of writes, it probably doesn't matter too much.
If you symlink the PGDATA directory, or have it in a mount you can move
then you can always change your mind later.
--
Richard Huxton
Archonet Ltd
