From: | John Smith <john_smith_45678(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: UPDATE slow |
Date: | 2003-02-04 22:37:48 |
Message-ID: | 20030204223748.80933.qmail@web40709.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If this helps :)
db=# explain analyze update stats set clicks = 3344 where link_id=1;
QUERY PLAN
---------------------------------------------------------------------------------------
Index Scan using idx_link_id on stats
(cost=0.00..149.42 rows=50 width=30) (actual time=0.58..727.45 rows=9994 loops=1)
Index Cond: (link_id = 1)
Total runtime: 8361.93 msec
(3 rows)
Just tried it on Linux - still takes 5-10 seconds. Any speed-up tips? Also tried it on MySQL and the update is nearly instantaneous :(.
John
I have about 11000 rows and this query is much slower than I expected:
update stats set clicks = 123;
stats is basically just: id, clicks; with indexes on each. Right now, the query takes about 10 seconds to execute. It's also on windows 2000/cygwin (if that contributes to slowness). Is it normal for updates like this on that many rows to take a while?
---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-02-04 22:40:35 | Re: UPDATE slow |
Previous Message | John Smith | 2003-02-04 22:28:19 | Re: UPDATE slow |