> 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 === > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > >
---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives?