pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
Date: Wed, 17 Nov 2010 16:49:51 +0100
Message-ID: <20101117164951.8f7692c2.l.steinborn@4c-ag.de> (raw)
In-Reply-To: <ic0onf$3fi$1@news.hub.org>
References: <ic0onf$3fi$1@news.hub.org>

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




view thread (12+ messages)  latest in thread

Message-ID: <20101117164951.8f7692c2.l.steinborn@4c-ag.de>
Permalink:  ../20101117164951.8f7692c2.l.steinborn@4c-ag.de/
Also on:    postgresql.org/message-id/20101117164951.8f7692c2.l.steinborn@4c-ag.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: l.steinborn@4c-ag.de
  Subject: Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
  In-Reply-To: <20101117164951.8f7692c2.l.steinborn@4c-ag.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox