Re: How to add big amounts of data into database?

----- Original Message -----
From: "Andrew Sullivan" <andrew(at)libertyrms(dot)info>
To: "Olonichev Sergei" <olonichev(at)scnsoft(dot)com>
Sent: 24 мая 2002 г. 18:50
Subject: Re: [GENERAL] How to add big amounts of data into database?

> On Fri, May 24, 2002 at 05:30:09PM +0300, Olonichev Sergei wrote:
> > Hello,
> >
> > Can anyone help me how to add big amount of data into database?
> >
> > I tried COPY, first the addition speed was good, but after each minute
it
> > became worser and worser.
>
> Do you have the indexes still on the table? If so, drop them and
> then recreate them afterwards.
>
> A
>
> > You can see the table illustrating this below.
> >
> > There were ~10,000,000 records.

!!!
> > There was no index created on table.

As I mentioned before no indexes were created.

BR,
Sergei