I use my laptop to execute the following sql, it's:
mydb=# update _mcir_2597431_clusterid2 set clusterid = 3;
UPDATE 104770
Time: 8666.447 ms
and on my pc:
mydb=# update _mcir_2597431_clusterid2 set clusterid = 3;
UPDATE 104770
Time: 27171.203 ms
First I wondered whether the write speed on pc is lower than laptop, so i use a cp command to test a write speed:
on my laptop:
postgres@postgres-laptop:~$ time cp backup/soft/data\ mining/SPSS\ Clementine\ v11.rar develop/
realÂÂÂ 0m19.403s
userÂÂÂ 0m0.032s
sysÂÂÂ 0m3.472s
on my pc:
postgres@postgres-laptop:~$ time cp backup/soft/data\ mining/SPSS\ Clementine\ v11.rar develop/
realÂÂÂ 0m9.192s
userÂÂÂ 0m0.008s
sysÂÂÂ 0m1.708s
so the writing speed on disk of pc is much faster than laptop, why the update sql command is much slower than my laptop? what's the reason causing such decrease?
