Test Environment Environment:
Notebook dual-core 1.5 GB, 2 GB memory, 5400 RPM hard drive.
Freebsd7.2 and Windows XP SP3 are both started. During the test, they are switched to two operating systems. The test client is Windows XP, another machine on the LAN, and the access interface is npgsql2. The development language is C #2.
Test Table content:
Cretate table T1 (TID varchar (50) TID is set as the primary key
Insert 20 thousand guids in two ways:
1. There is no explicit transaction, that is, an implicit transaction automatically exists for each inserted transaction.
2. Start a transaction, insert 20 thousand records, and commit is displayed.
Result (take the stable value for multiple executions ):
Windowxp:
1. Implicit transactions 45 m 2. explicit transactions 15 m
Freebsd7.2:
1. Implicit Transaction 42 m 2. Explicit transaction 7 m
Comparison data:
The comparison environment is ms SQL server2005. On a strong Windows2003 server, although many things are installed, the development server does not have many tasks.
1. Implicit Transaction 140 m 2. Explicit transaction: 21 m
Result:
The insert performance of pgsql on FreeBSD is slightly higher than that on Win (single user, no concurrency ).
Others:
I have a test http://www.cnblogs.com/81/archive/2008/12/06/1348896.html in front
It indicates that mssql2000 is slightly better than pgsql83, but today's comparison data mssql2005 is slightly worse than pgsql84, which is not expected, but there is a difference: last time, the client and server were both on one machine (taking the memory copy, the speed is fast), and this time they were on two machines (taking the TCP/IP, Which is slower than the memory copy ).