Re: Performance UPDATE/INSERT
От | MG |
---|---|
Тема | Re: Performance UPDATE/INSERT |
Дата | |
Msg-id | 000301c65d4a$e9c36e60$340aa8c0@geisslinger обсуждение исходный текст |
Ответ на | Performance UPDATE/INSERT ("MG" <pgsql-general@carladata.de>) |
Ответы |
Re: Performance UPDATE/INSERT
Re: Performance UPDATE/INSERT |
Список | pgsql-general |
I can`t use COPY for INSERTs, because I have to manipulate each record indiviuell. But the problem is the UPDATEs Greetings Michaela ----- Original Message ----- From: "A. Kretschmer" <andreas.kretschmer@schollglas.com> To: <pgsql-general@postgresql.org> Sent: Tuesday, April 11, 2006 11:20 AM Subject: Re: [GENERAL] Performance UPDATE/INSERT > 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 > >
В списке pgsql-general по дате отправления: