On 2010-12-26, sunpeng wrote:
> First I wondered whether the write speed on pc is lower than laptop, so i
> use a cp command to test a write speed:
that is often a test of read speed only.
as the writes will be cached.
--
⚂⚃ 100% natural
--
Sent via pgsql-general mailing list (pgsql-general@
On Sun, Dec 26, 2010 at 5:35 AM, sunpeng wrote:
> 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
On 2010/12/26, at 21:35, sunpeng wrote:
> 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?
Are those PostgreSQL versions and/or configurations completely same?
How about shared_b
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