Re: Yet another Performance Question

On Wed, Apr 18, 2001 at 02:59:53PM +0200, Patrik Kudo wrote:
> Hi!
>
> I'm not 100% sure, but I think it would be much faster if you use COPY
> instead of INSERT when you read in a lot of data from a file.
Well unless I am the database owner I only can do \copy and the script does
some manipulation before it inserts...

Konstantin
>
> Regards,
> Patrik Kudo
>
> --
> ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol
> Känns det oklart? Fråga på!
>
> On Wed, 18 Apr 2001, Konstantinos Agouros wrote:
>
> > Frankly what matters is the time it takes alltogether. I have a script that
> > first does a few million inserts, and than queries on this data... these queries
> > don't terminate in a reasonable (<10days) time, if I don't use indices.
> >
> > So I will add some drop/create index-commands to the script...
> >
> > Konstantin
>

--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres