Postgres Pro
Downloads
Home   >   mailing lists

Re: performance for high-volume log insertion - Mailing list pgsql-performance

From Stephen Frost
Subject Re: performance for high-volume log insertion
Date
Msg-id 20090421031518.GT8123@tamriel.snowman.net
Whole thread Raw
In response to Re: performance for high-volume log insertion  (Greg Smith <gsmith@gregsmith.com>)
Responses Re: performance for high-volume log insertion  (david@lang.hm)
List pgsql-performance
Tree view 
Greg,

* Greg Smith (gsmith@gregsmith.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
Attachment

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: performance for high-volume log insertion
Next
From: david@lang.hm
Date:
Subject: Re: performance for high-volume log insertion