win环境跟linux环境的pgsql连接速度相差很大

[yuzifu]

A：win2k3+pgsql8.3
B: ubuntu804server+pgsql8.3
两个环境均无防火墙、pgsql配置是一样，数据库、表也是一样的。

我从客户端C使用postgresqldirect连接到A、B两台的pgsql，花费时间
A：<1秒
B: ~6秒


连接时两个环境产生的日志：
A:
2009-01-07 10:28:31 HKT 3980 4964134f.f8c日志: connection received: host=192.168.0.60 port=1094
2009-01-07 10:28:31 HKT 3980 4964134f.f8c日志: 联接认证: 主机=demo 数据库=demo
2009-01-07 10:28:31 HKT 3980 4964134f.f8c日志: execute PRSTMT5109743807255875/PORTAL5109743807255875: SELECT version()
2009-01-07 10:28:32 HKT 3980 4964134f.f8c日志: execute PRSTMT2712195627255906/PORTAL2712195627255906: show integer_datetimes
2009-01-07 10:28:32 HKT 3980 4964134f.f8c日志: execute PRSTMT15249056447255906/PORTAL15249056447255906: SET autocommit=true
2009-01-07 10:28:32 HKT 3980 4964134f.f8c日志: execute PRSTMT17568336297255921/PORTAL17568336297255921: SET datestyle=ISO
2009-01-07 10:28:32 HKT 3980 4964134f.f8c日志: execute PRSTMT11411184127255921/PORTAL11411184127255921: SET client_encoding='UTF8'
2009-01-07 10:28:32 HKT 3980 4964134f.f8c日志: execute PRSTMT9432671627255937/PORTAL9432671627255937: select * from demo;
2009-01-07 10:28:32 HKT 3980 4964134f.f8c日志: execute PRSTMT695653677255953/PORTAL695653677255953: rollback
2009-01-07 10:28:32 HKT 3980 4964134f.f8c注意: 没有事物在运行中


B:
2009-01-07 10:28:30 CST 4123 49641349.101b日志: connection received: host=192.168.0.60 port=1095
2009-01-07 10:28:30 CST 4123 49641349.101b日志: 联接认证: 主机=demo 数据库=demo
2009-01-07 10:28:30 CST 4123 4964134e.101b日志: execute PRSTMT5109743807262375/PORTAL5109743807262375: SELECT version()
2009-01-07 10:28:30 CST 4123 4964134e.101b日志: execute PRSTMT2712195627262406/PORTAL2712195627262406: show integer_datetimes
2009-01-07 10:28:30 CST 4123 4964134e.101b日志: execute PRSTMT15249056447262421/PORTAL15249056447262421: SET autocommit=true
2009-01-07 10:28:30 CST 4123 4964134e.101b日志: execute PRSTMT17568336297262421/PORTAL17568336297262421: SET datestyle=ISO
2009-01-07 10:28:30 CST 4123 4964134e.101b日志: execute PRSTMT11411184127262421/PORTAL11411184127262421: SET client_encoding='UTF8'
2009-01-07 10:28:31 CST 4123 4964134e.101b日志: execute PRSTMT9432671627262437/PORTAL9432671627262437: select * from demo;
2009-01-07 10:28:31 CST 4123 4964134e.101b日志: execute PRSTMT695653677262453/PORTAL695653677262453: rollback
2009-01-07 10:28:31 CST 4123 4964134e.101b注意: 没有事物在运行中

[yuzifu]

原因是win环境下的配置文件没有启用ssl，而ubuntu环境下的配置文件启用了ssl，关掉ubuntu环境下配置文件的ssl即可。

[rocisky]

恩，不错 !!感谢分享～～