UPDATE slow - Mailing list pgsql-general

From John Smith
Subject UPDATE slow
Date
Msg-id 20030204045031.68519.qmail@web40709.mail.yahoo.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Xemacs compile error
Next
From: Lee Harr
Date:
Subject: Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4