Skip site navigation (1) Skip section navigation (2)

Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins

From: Lutz Steinborn <l(dot)steinborn(at)4c-ag(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
Date: 2010-11-17 15:49:51
Message-ID: 20101117164951.8f7692c2.l.steinborn@4c-ag.de (view raw or flat)
Thread:
Lists: pgsql-performance
On Wed, 17 Nov 2010 09:26:56 -0500
Eric Comeau <ecomeau(at)signiant(dot)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


In response to

pgsql-performance by date

Next:From: Ivan VorasDate: 2010-11-17 16:12:44
Subject: Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
Previous:From: DigimerDate: 2010-11-17 15:28:24
Subject: Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group