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

Re: INSERT performace.

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: INSERT performace.
Date: 2002-01-30 17:56:36
Message-ID: 20020130095636.B47442@ninja1.internal (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
> > How were you inserting the data?  Were you doing multiple inserts per
> > transactions?  Copy?  That sounds really slow to me.
> The database mainly contains integers, which represent the behavior of 
> internet users on our site, so it's very compact data.
> We used multiple insert with mysql but i did'nt find that option in postgres.

INSERT INTO table (val1, val2, val3) VALUES (1,2,3);
INSERT INTO table (val1, val2, val3) VALUES (4,5,6);
INSERT INTO table (val1, val2, val3) VALUES (7,8,9);
INSERT INTO table (val1, val2, val3) VALUES (10,11,12);

> > > By testing we created a postgres database to on an other server
> > > (same type).  The copy command did'nt work, because of 'strange
> > > characters', so we used normal inserts. It took us 12 hours to
> > > import, and 10 hours to create the indexes.
> >
> > Have you tried to escape the data before you inserted it?  That
> > should've solve things.
> No, how do you do that ?

Do you know what those 'strange characters' are?  -sc

Sean Chittenden

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2002-01-30 17:58:04
Subject: Re: postgresql under Windows is slow
Previous:From: Naomi WalkerDate: 2002-01-30 17:31:29
Subject: Re: Backup database through web and php

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