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

Re: performance for high-volume log insertion

From: Glenn Maynard <glennfmaynard(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: performance for high-volume log insertion
Date: 2009-04-22 21:04:43
Message-ID: bd36f99e0904221404n1390e7f0y538b7a42d7fdd411@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Wed, Apr 22, 2009 at 4:07 PM,  <david(at)lang(dot)hm> wrote:
> are these done as seperate round trips?
>
> i.e.
> begin <send>
> insert <send>
> insert <send>
> ..
> end <send>
>
> or as one round trip?

All tests were done by constructing a file and using "time psql -f ...".

>> 40 inserts, 100 rows/insert: 0.18s
>> one 40000-value insert: 0.16s
>> 40 prepared inserts, 100 rows/insert: 0.15s
>
> are one of these missing a 0?

Sorry, 400 * 100.  All cases inserted 40000 rows, and I deleted all
rows between tests (but did not recreate the table).

-- 
Glenn Maynard

In response to

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2009-04-22 21:17:43
Subject: Re: performance for high-volume log insertion
Previous:From: James MansionDate: 2009-04-22 20:53:03
Subject: Re: performance for high-volume log insertion

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