Re: How to add big amounts of data into database? - Mailing list pgsql-general

From Olonichev Sergei
Subject Re: How to add big amounts of data into database?
Date
Msg-id 01a301c2033b$671a0ef0$f566a8c0@olonichev
Whole thread Raw
In response to How to add big amounts of data into database?  ("Olonichev Sergei" <olonichev@scnsoft.com>)
List pgsql-general
----- Original Message -----
From: "Andrew Sullivan" <andrew@libertyrms.info>
To: "Olonichev Sergei" <olonichev@scnsoft.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




pgsql-general by date:

Previous
From: "Joel Burton"
Date:
Subject: Re: user defined variables
Next
From: Moritz Sinn
Date:
Subject: Re: user defined variables