Re: Low performance on Windows problem - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Low performance on Windows problem
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD315@Herge.rcsinc.local
Whole thread Raw
In response to Low performance on Windows problem  (Dalibor Sramek <dali@insula.cz>)
Responses Re: Low performance on Windows problem  (Dalibor Sramek <dali@insula.cz>)
List pgsql-performance
> On Tue, Sep 13, 2005 at 07:58:20AM -0400, Merlin Moncure wrote:
> This command is executed while a model is loaded from the repository.
>
> The table definition is:
> CREATE TABLE t_umlpattern (
>     PatternID INTEGER DEFAULT nextval('"patternid_seq"'::text) NOT
NULL
> PRIMARY KEY,
>     PatternCategory VARCHAR(100),
>     PatternName VARCHAR(150),
>     Style VARCHAR(250),
>     Notes TEXT,
>     PatternXML TEXT,
>     Version VARCHAR(50)
> );
>
> It has just 23 rows but the PatternXML column is rather large. The
table
> dump has over 900 kB.
>
> Now
> 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 I guess the problem is in the transfer of the bigger amount of data
> from
> the Windows server.
>
> I put the dump at http://www.insula.cz/dali/misc/table.zip
>
> Could anybody confirm the difference?

I loaded your dump and was able to select entire table in trivial time
from both pgAdmin and psql shell.  I am suspecting some type of tcp
problem here.  Can you confirm slow times on unloaded server?

Merlin

pgsql-performance by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Performance considerations for very heavy INSERT traffic
Next
From: Dalibor Sramek
Date:
Subject: Re: Low performance on Windows problem