El 06/02/11 20:05, Scott Marlowe escribió:
On Sun, Feb 6, 2011 at 11:16 AM, Linos<info@xxxxxxxx> wrote:
I am searching what would be the best hardware combination to a new server i
have to install, the new server will have a Postgresql 9.0 with a database
of about 10gb, the database part it is not the problem for me, in this size
almost, the part where i am a bit lost is that i have to share from the same
server about 20TB of data with samba or ISCSI (i have to test both ways to
share when i have the hardware) because this is to be the file-server of 8
Avid video workstations.
I am pretty sure that the Postgresql should be installed in a raid10
configuration wigh pg_xlog in a different physical volume, i know too that
the most important things to Postgresql are memory and disks, i will get a
raid card with BBU or flash cache to be safe with write caching.
I'd put all of pgsql on a different card than the file share.
This should not be a problem, i think you have reason here maybe i could use
internal disks and 1 raid card for Postgresql.
About the file-server part the files we are going to move are in the range
of 1gb~4gb in mostly a sequential access nature for what i have read of how
avid works, so i think the best would be a raid 6 here, but i am not sure
what hardware to buy because i have not stored never this quantity of
storage, i have read in this mailing list other times about external
enclosure boxes to attach storage and i have read raid cards recommendations
before, lsi, 3ware or areca seems safe bets but i don't know how to put all
the pieces together.
If the data on this is considered disposable, then you could look at
RAID-0 for the fastest performance. Even with SW RAID0 you'd get
incredible throughput with a few disks.
It is not disposable, all the contrary, i have to take special care of the this
files :)
I am studying too the possibility of use an OCZ Vertex 2 Pro with Flashcache
or Bcache to use it like a second level filesystem cache, any comments on
that please?
My coworkers RAVE over ZFS solaris with flash drives for cache and
spinning drives for mass storage.
i think neither flashcache nor bcache are at the level of zfs with l2arc in ssd
but should perform well anyway, what it is the preferred way of use good raid
cards with zfs? jbod and configure in raid-z? i have not used zfs still.
Regards,
Miguel Angel.
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
