On Fri, Jun 23, 2000 at 12:00:31PM -0400, Tom Lane wrote: > Jim Mercer <[EMAIL PROTECTED]> writes: > > it appears that each call to UPDATE seems to be taking a long, long time to > > complete. > > Poor choice of plan, maybe? What does EXPLAIN say about how a typical > example of the UPDATE will be executed? silly me, i should have know to do more investigation before going to the list. as it turns out, the index on the key was not being used. a "vacuum verbose analyze" caused things to run much, much faster. (hence the UPDATE ... WHERE key = ... was taking extra long) -- [ Jim Mercer [EMAIL PROTECTED] +1 416 410-5633 ] [ Reptilian Research -- Longer Life through Colder Blood ] [ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]
