From: | Jim Mercer <jim(at)reptiles(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: followup to SELECT/INSERT problem |
Date: | 2000-06-23 17:54:16 |
Message-ID: | 20000623135415.J24735@reptiles.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jun 23, 2000 at 12:00:31PM -0400, Tom Lane wrote:
> Jim Mercer <jim(at)reptiles(dot)org> 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 jim(at)reptiles(dot)org +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. ]
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2000-06-23 18:06:50 | Re: Need to improve performance |
Previous Message | Vassili A Akimov | 2000-06-23 17:43:52 | Re: Need to improve performance |