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 ===