On 07/24/2012 08:51 AM, Laszlo Nagy wrote:
When Intel RAID controller is that? All of the ones on the motherboard
are pretty much useless if that's what you have. Those are slower than
software RAID and it's going to add driver issues you could otherwise
avoid. Better to connect the drives to the non-RAID ports or configure
the controller in JBOD mode first.

Using one of the better RAID controllers, one of Dell's good PERC models
for example, is one of the biggest hardware upgrades you could make to
this server. If your database is mostly read traffic, it won't matter
very much. Write-heavy loads really benefit from a good RAID
controller's write cache.

You should be able to get UFS working with a software mirror and
journaling using gstripe/gmirror or vinum. It doesn't matter that much
for PostgreSQL though. The data writes are journaled by the database,
and it tries to sync data to disk after updating metadata too. There
are plenty of PostgreSQL installs on FreeBSD/UFS that work fine.

ZFS needs more RAM and has higher CPU overhead than UFS does. It's a
heavier filesystem all around than UFS is. Your server is fast enough
that you should be able to afford it though, and the feature set is
nice. In addition to the RAID setup being simple to handle, having
checksums on your data is a good safety feature for PostgreSQL.

ZFS will heavily use server RAM for caching by default, much more so
than UFS. Make sure you check into that, and leave enough RAM for the
database to run too. (Doing *some* caching that way is good for
Postgres; you just don't want *all* the memory to be used for that)

Moving disks to another server is a very low probability fix for a
broken system. The disks are a likely place for the actual failure to
happen at in the first place. I like to think more in terms of "how can
I create a real-time replica of this data?" to protect databases, and
the standby server for that doesn't need to be an expensive system.
That said, there is no reason to set things up so that they only work
with that Intel RAID controller, given that it's not a very good piece
of hardware anyway.

Hello,
The Postres 9.0 database we use gets about 20K inserts per minute. As
long as you don't query at the same time the database is copying fine.
However long running queries seems to delay so much the db that the
application server buffers the incoming data as it cannot insert them
fast enough. The server has 4 HD. One is used for archive, past static
tables, the second is the index of the current live tables and the third
is the current data. The fourth is the OS.

The serve specs are:
Intel(R) Xeon(R) CPU W3520 @ 2.67GHz
4 cores
18GB Ram

Do you think that this work load is high that requires an upgrade to
cluster or RAID 10 to cope with it?

Kind Regards
Yiannis