Re: slow speeds after 2 million rows inserted

[Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com>]

Joshua D. Drake wrote:
> On Fri, 2006-12-29 at 13:21 -0500, James Neff wrote:
> > Joshua D. Drake wrote:
> > > Also as you are running 8.2 you can use multi valued inserts...
> > >
> > > INSERT INTO data_archive values () () ()
> > >   
> > Would this speed things up? Or is that just another way to do it?
>
> The fastest way will be copy.
> The second fastest will be multi value inserts in batches.. eg.;
>
> INSERT INTO data_archive values () () () (I don't knwo what the max is)
>
> but commit every 1000 inserts or so.
>
> Sincerely,
>
> Joshua D. Drake
>
>
> > Thanks,
> > James
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: explain analyze is your friend

Another thing....if you have to make validations and so on....creating 
an temp file with the information validated and using COPY will be 
faster. So you can validate and use COPY at the same time....