| From: | John Smith <john_smith_45678(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | pgsql-cygwin(at)postgresql(dot)org |
| Subject: | UPDATE slow |
| Date: | 2003-02-04 04:50:31 |
| Message-ID: | 20030204045031.68519.qmail@web40709.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-cygwin pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Tishler | 2003-02-04 18:24:16 | Re: question |
| Previous Message | S. L. | 2003-02-03 07:40:01 | Re: Postgres 7.3 from source --with-tcl : Errors again... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lee Harr | 2003-02-04 04:51:41 | Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 |
| Previous Message | Chris Travers | 2003-02-04 04:46:35 | Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 |