>  Total runtime: 3.56 msec
> (4 rows)

Well, from that figure it's not the query that's holding you up.    

You said that the system bogs down when you're doing a whole series of these 
updates, or just one?   If the former, then I'm afraid that it's your disk 
that's to blame ... large numbers of rapid-fire updates simply won't be fast 
on a single IDE disk.   Try getting a second disk and moving the transaction 
log to it.

Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to