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: Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: performance for high-volume log insertion
Date: 2009-04-21 06:45:54
Message-ID: 20090421064554.GW8123@tamriel.snowman.net (view raw or flat)
Thread:
Lists: pgsql-performance
* david(at)lang(dot)hm (david(at)lang(dot)hm) wrote:
> while I fully understand the 'benchmark your situation' need, this isn't  
> that simple.

It really is.  You know your application, you know it's primary use
cases, and probably have some data to play with.  You're certainly in a
much better situation to at least *try* and benchmark it than we are.

> in this case we are trying to decide what API/interface to use in a  
> infrastructure tool that will be distributed in common distros (it's now  
> the default syslog package of debian and fedora), there are so many  
> variables in hardware, software, and load that trying to benchmark it  
> becomes effectivly impossible.

You don't need to know how it will perform in every situation.  The main
question you have is if using prepared queries is faster or not, so pick
a common structure, create a table, get some data, and test.  I can say
that prepared queries will be more likely to give you a performance
boost with wider tables (more columns).

> based on Stephan's explination of where binary could help, I think the  
> easy answer is to decide not to bother with it (the postgres text to X  
> converters get far more optimization attention than anything rsyslog 
> could deploy)

While that's true, there's no substitute for not having to do a
conversion at all.  After all, it's alot cheaper to do a bit of
byte-swapping on an integer value that's already an integer in memory
than to sprintf and atoi it.

	Thanks,

		Stephen

In response to

Responses

pgsql-performance by date

Next:From: Stephen FrostDate: 2009-04-21 06:50:59
Subject: Re: performance for high-volume log insertion
Previous:From: Stephen FrostDate: 2009-04-21 06:41:38
Subject: Re: performance for high-volume log insertion

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