Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins - Mailing list pgsql-performance

From Lutz Steinborn
Subject Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
Date
Msg-id 20101117164951.8f7692c2.l.steinborn@4c-ag.de
Whole thread Raw
In response to How to achieve sustained disk performance of 1.25 GB write for 5 mins  (Eric Comeau <ecomeau@signiant.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Digimer
Date:
Subject: Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
Next
From: Ivan Voras
Date:
Subject: Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins