Date: Wed, 17 Nov 2010 16:49:51 +0100
From: Lutz Steinborn <l.steinborn@4c-ag.de>
To: pgsql-performance@postgresql.org
Subject: Re: How to achieve sustained disk performance of 1.25 GB
	write for 5 mins
Message-Id: <20101117164951.8f7692c2.l.steinborn@4c-ag.de>
In-Reply-To: <ic0onf$3fi$1@news.hub.org>
References: <ic0onf$3fi$1@news.hub.org>
Organization: 4c AG
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

On Wed, 17 Nov 2010 09:26:56 -0500
Eric Comeau <ecomeau@signiant.com> wrote:

> This is not directly a PostgreSQL performance question but I'm hoping 
> some of the chaps that build high IO PostgreSQL servers on here can help.
> 
> We build file transfer acceleration s/w (and use PostgreSQL as our 
> database) but we need to build a test server that can handle a sustained 
> write throughput of 1,25 GB for 5 mins.
> 
> Why this number, because we want to push a 10 Gbps network link for 5-8 
> mins, 10Gbps = 1.25 GB write, and would like to drive it for 5-8 mins 
> which would be 400-500 GB.
> 
> Note this is just a "test" server therefore it does not need fault 
> tolerance.

Get a machine with enough RAM and run postgresql from RAM disk. Write a
start script to copy the RAM disk back to normal disk then stopping and back
to RAM disk for start.

this must be the fastest solution.

-- 
Lutz