Re: insert performance for win32 - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: insert performance for win32
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD28C@Herge.rcsinc.local
Whole thread Raw
In response to insert performance for win32  (Marc Cousin <mcousin@sigma.fr>)
List pgsql-performance
> > One thing I did notice that in a 250k insert transaction the insert
time
> > grows with #recs inserted.  Time to insert first 50k recs is about
27
> > sec and last 50 k recs is 77 sec.  I also confimed that size of
table is
> > not playing a role here.
> >
> > Marc, can you do select timeofday() every 50k recs from linux?  Also
a
> > gprof trace from linux would be helpful.
> >
>
> Here's the timeofday ... i'll do the gprof as soon as I can.
> Every 50000 rows...
>
Were those all in a single transaction?

Merlin

pgsql-performance by date:

Previous
From: Marc Cousin
Date:
Subject: Re: insert performance for win32
Next
From: "Merlin Moncure"
Date:
Subject: Re: insert performance for win32