Re: Performance UPDATE/INSERT

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance UPDATE/INSERT
Date: 2006-04-11 09:20:32
Message-ID: 20060411092032.GD5520@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

am 11.04.2006, um 11:08:57 +0200 mailte MG folgendes:
> Hello,
>
> I have about 100 000 records, which need about 30 minutes to write them with single INSERTs into PostgreSQL.

You should better use the COPY - command for bulk inserts. This is
faster.

HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-04-11 09:24:19 Re: Debian package for freeradius_postgresql module
Previous Message MG 2006-04-11 09:08:57 Performance UPDATE/INSERT