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

Re: performance for high-volume log insertion

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: david(at)lang(dot)hm, pgsql-performance(at)postgresql(dot)org
Subject: Re: performance for high-volume log insertion
Date: 2009-04-21 03:15:18
Message-ID: 20090421031518.GT8123@tamriel.snowman.net (view raw or flat)
Thread:
Lists: pgsql-performance
Greg,

* Greg Smith (gsmith(at)gregsmith(dot)com) wrote:
> The win from switching from INSERT to COPY can be pretty big, further  
> optimizing to BINARY you'd really need to profile to justify.  

Have you done any testing to compare COPY vs. INSERT using prepared
statements?  I'd be curious to know how those compare and against
multi-value INSERTS, prepared and unprepared.

	Thanks,

		Stephen

In response to

Responses

pgsql-performance by date

Next:From: davidDate: 2009-04-21 03:29:54
Subject: Re: performance for high-volume log insertion
Previous:From: Greg SmithDate: 2009-04-21 03:12:25
Subject: Re: performance for high-volume log insertion

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