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

Re: performance for high-volume log insertion

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: david(at)lang(dot)hm
Cc: Glenn Maynard <glennfmaynard(at)gmail(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: performance for high-volume log insertion
Date: 2009-04-23 01:50:36
Message-ID: 20090423015036.GL8123@tamriel.snowman.net (view raw or flat)
Thread:
Lists: pgsql-performance
* david(at)lang(dot)hm (david(at)lang(dot)hm) wrote:
> On Wed, 22 Apr 2009, Glenn Maynard wrote:
>> You're talking about round-trips to a *local* server, on the same
>> system, not a dedicated server with network round-trips, right?
>
> the use-case for a production setup for logging servers would probably  
> include a network hop.

Sure, but there's a big difference between a rtt of 0.041ms (my dinky
home network) and 20ms (from my home network in Virginia to Boston).  I
wasn't intending to discount latency, it can be a concen, but I doubt
it'll be 20ms for most people..

	Thanks,

		Stephen

In response to

pgsql-performance by date

Next:From: Glenn MaynardDate: 2009-04-23 02:20:41
Subject: Re: performance for high-volume log insertion
Previous:From: davidDate: 2009-04-22 22:46:30
Subject: Re: performance for high-volume log insertion

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