pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Markus Schiltknecht <markus@bluegap.ch>
To: Decibel! <decibel@decibel.org>
Cc: Maila Fatticcioni <mfatticcioni@mbigroup.it>
Cc: pgsql-performance@postgresql.org
Subject: Re: DRBD and Postgres: how to improve the perfomance?
Date: Mon, 17 Sep 2007 17:19:31 +0200
Message-ID: <46EE9B03.3000809@bluegap.ch> (raw)
In-Reply-To: <20070911212201.GD38801@decibel.org>
References: <46E11BE4.6060500@mbigroup.it>
	<1189191616.4281.1.camel@ebony.site>
	<46E6AA8C.8030504@mbigroup.it>
	<20070911145724.GB2620@uio.no>
	<20070911212201.GD38801@decibel.org>

Hi,

Decibel! wrote:
> Actually, in this case, I suspect that latency will be far more critical
> than overall bandwidth. I don't know if it's inherent to Gig-E, but my
> limited experience has been that Gig-E has higher latency than 100mb.

I've been looking for some benchmarks, but it's rather hard to find. It 
looks like people are much more concerned about throughput ?!?

However, I'd like to share some of the sites I've found, especially 
regarding Fast Ethernet vs. Gigabit Ethernet:

  - Ashford Computer Consulting Service benchmarked five different 
gigabit ethernet adapters [1], back in 2004. For most cards they 
measured between ca. 100 -  150 microseconds for a UDP round trip of a 
token, a so called hot potato benchmark. Unfortunately they didn't 
compare with Fast Ethernet.

  - The NetPIPE project has some of it's measurements at the very bottom 
of it's website [2]. Mostly for high speed and low latency links. Again, 
Fast Ethernet is missing. The diagram tells the following latencies (in 
microseconds):

      75   10 Gigabit Ethernet
      62   Gigabit Ethernet
       8   Myrinet
       7.5 Infini Band
       4.7 Atoll
       4.2 SCI

I've no explanation for the significantly better measure for gigabit 
ethernet compared with the above benchmark. From their description I'm 
concluding that they also measured a round-trip, but not via UDP.

The bad value for 10 Gigabit Ethernet is due to a poor Intel adapter, 
which also has poor throughput. They claim that newer adapters are better.

  - Finally, I've found a latency comparison between Fast vs Gigabit 
Ethernet, here [3]. Figure 6, in the second third of the page shows a 
NetPIPE latency benchmark between Ethernet, Fast Ethernet and Gigabit 
Ethernet (additionally ATM and FDDI). It looks like Gigabit Ethernet 
features slightly better latency.

 From these findings I'm concluding, that commodity Ethernet hardware 
has quite similar latencies, no matter if you are using Fast, Gigabit or 
10 Gigabit Ethernet. If you really want to have a low latency 
interconnect, you need to pay the extra bucks for specialized, low 
latency networking hardware (which may still be based on 10GE, see 
Myrinet's 10GE adapter).

If you know other resources, I'd be curious to know.

Regards

Markus

[1]: Ashford Computer Consulting Service, GigE benchmarks:
http://www.accs.com/p_and_p/GigaBit/conclusion.html

[2]: NetPIPE website:
http://www.scl.ameslab.gov/netpipe/

[3]: Gigabit Ethernet and Low-Cost Supercomputing
http://www.scl.ameslab.gov/Publications/Gigabit/tr5126.html



view thread (28+ messages)

Message-ID: <46EE9B03.3000809@bluegap.ch>
Permalink:  ../46EE9B03.3000809@bluegap.ch/
Also on:    postgresql.org/message-id/46EE9B03.3000809@bluegap.ch

 · 

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: markus@bluegap.ch, decibel@decibel.org, mfatticcioni@mbigroup.it
  Subject: Re: DRBD and Postgres: how to improve the perfomance?
  In-Reply-To: <46EE9B03.3000809@bluegap.ch>

* 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