Re: slow speeds after 2 million rows inserted - Mailing list pgsql-general

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
>
--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate