I've been searching the list for a while but couldn't find any up-to-date
information relating to my problem.
We have a production server with postgresql on cygwin that currently deels
with about 200 Gigs of data (1 big IDE drive). We plan to move to linux
for some reasons I don't have to explain.
Our aim is also to be able to increase our storage capacity up to
approximately 1 or 2 terabytes and to speed up our production process. As
we are a small "microsoft addicted" company , we have some difficulties to
choose the best configuration that would best meet our needs.
Our production process is based on transaction (mostly huge inserts) and
disk access is the main bottlle-neck.
Our main concern is hardware related :
Would NAS or SAN be good solutions ? (I've read that NAS uses NFS which
could slow down the transfer rate ??)
Has anyone ever tried one of these with postgresql ?
I would appreciate any comments.
Thanks in advance.
Benjamin Simon - Ingénieur Développement Cartographie
tel : 01 30 40 24 00
Fax : 01 30 40 24 04
271, Chaussée Jules César 95250 Beauchamp
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2004-07-20 08:20:56|
|Subject: Re: NAS, SAN or any alternate solution ?|
|Previous:||From: Andy Ballingall||Date: 2004-07-19 09:12:12|
|Subject: Re: Working on huge RAM based datasets|