Rhaoni,
> 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