Re: [PERFORM] NAS, SAN or any alternate solution ?

2004-09-22 Thread Andrew Hammond
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rod Taylor wrote: | I've used both a NetApp and Hitachi based SANs with PostgreSQL. Both | work as well as expected, but do require some tweeking as they normally | are not optimized for the datablock size that PostgreSQL likes to deal | with (8k by

Re: [PERFORM] NAS, SAN or any alternate solution ?

2004-09-22 Thread Rod Taylor
Rod Taylor wrote: | I've used both a NetApp and Hitachi based SANs with PostgreSQL. Both | work as well as expected, but do require some tweeking as they normally | are not optimized for the datablock size that PostgreSQL likes to deal | with (8k by default) -- this can make as much as a 50%

Re: [PERFORM] NAS, SAN or any alternate solution ?

2004-09-22 Thread Greg Stark
Andrew Hammond [EMAIL PROTECTED] writes: My goal is to tune the disk / filesystem on our prototype system. It's an EMC disk array, so sectors on disk are 512 bytes of usable space. We've decided to go with RAID 10 since the goal is to maximize performance. Currently the raid element size is

[PERFORM] NAS, SAN or any alternate solution ?

2004-07-20 Thread bsimon
Hi all, 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

Re: [PERFORM] NAS, SAN or any alternate solution ?

2004-07-20 Thread Scott Marlowe
On Tue, 2004-07-20 at 01:52, [EMAIL PROTECTED] wrote: Hi all, 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

Réf. : Re: [PERFORM] NAS, SAN or any alternate solution ?

2004-07-20 Thread bsimon
. Benjamin. Scott Marlowe [EMAIL PROTECTED] Envoyé par : [EMAIL PROTECTED] 20/07/2004 10:20 Pour :[EMAIL PROTECTED] cc :[EMAIL PROTECTED] Objet :Re: [PERFORM] NAS, SAN or any alternate solution ? On Tue, 2004-07-20 at 01:52, [EMAIL PROTECTED] wrote: Hi all, I've

Réf. : Re: Réf. : Re: [PERFORM] NAS, SAN or any alternate solution ?

2004-07-20 Thread bsimon
. Regards, Benjamin. Mark Kirkwood [EMAIL PROTECTED] 20/07/2004 12:04 Pour :[EMAIL PROTECTED] cc :[EMAIL PROTECTED] Objet :Re: Réf. : Re: [PERFORM] NAS, SAN or any alternate solution ? [EMAIL PROTECTED] wrote: As we don't plan to have more than 5 connections

Re: [PERFORM] NAS, SAN or any alternate solution ?

2004-07-20 Thread Grega Bremec
...and on Tue, Jul 20, 2004 at 09:52:56AM +0200, [EMAIL PROTECTED] used the keyboard: Hi all, 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

Re: [PERFORM] NAS, SAN or any alternate solution ?

2004-07-20 Thread Grega Bremec
Oh, and not to forget - the price for a 3ware 9500S-12, the version we're testing ranges between EUR1000 and EUR1500, depending on the contract you have with the reseller and the intended use of the device. SATA disks are dirt-cheap nowadays, as has been mentioned before. Correction,

Re: [PERFORM] NAS, SAN or any alternate solution ?

2004-07-20 Thread Joe Conway
[EMAIL PROTECTED] wrote: 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 ? Not (yet) with Postgres, but my company has run ~100GB Oracle database on NAS (NetApp) for the past couple