Dalibor Sramek <dali(at)insula(dot)cz> writes:
> select * from t_umlpattern limit 2
> takes 1500+ msec on the Windows machine and 60 on a comparable Linux
> machine. Both selects performed from remote PgAdmin.
> The same select performed localy on the windows machine takes 60 msec.
So it's a networking issue. I haven't paid real close attention to
Windows problems, but I recall that we've heard a couple of reports
of Windows performance problems that were resolved by removing various
third-party network filters and/or installing Windows service pack
updates. Check through the list archives ...
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Ian Westmacott||Date: 2005-09-13 16:16:55|
|Subject: Re: Performance considerations for very heavy INSERT|
|Previous:||From: Brandon Black||Date: 2005-09-13 15:30:59|
|Subject: Re: Performance considerations for very heavy INSERT traffic|