am 11.04.2006, um 11:32:55 +0200 mailte MG folgendes: > I can`t use COPY for INSERTs, because I have to manipulate each record > indiviuell. > > But the problem is the UPDATEs
test=# \timing Timing is on. test=# update mira set y = 123; UPDATE 150000 Time: 1874.894 ms 150 000 Records, a simple table with 2 int-columns. Have you run vacuum? Which version? Can you tell us the explain for the update? > > Greetings > Michaela > > ----- Original Message ----- From: "A. Kretschmer" Please, no silly TOFU. 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 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
