Lincoln Yeoh <[EMAIL PROTECTED]> writes: > ...By the way, are updates treated the same as selects by the optimizer?
Yeah. The writes must occur in any case, so I see no reason why the optimizer should worry about them. All it needs to consider are the cycles used by the various alternatives for fetching the data. So the problem is isomorphic to a SELECT. This assumption is really wired quite fundamentally into the optimizer, but I'm not sure if it's made clear anywhere in the documentation. Can anyone suggest the right place to describe it? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])