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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message david 2009-04-21 03:29:54 Re: performance for high-volume log insertion
Previous Message Greg Smith 2009-04-21 03:12:25 Re: performance for high-volume log insertion