From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
---|---|
To: | "Dalibor Sramek" <dali(at)insula(dot)cz> |
Cc: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Low performance on Windows problem |
Date: | 2005-09-13 14:20:05 |
Message-ID: | 6EE64EF3AB31D5448D0007DD34EEB3417DD315@Herge.rcsinc.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Dalibor Sramek | 2005-09-13 14:34:02 | Re: Low performance on Windows problem |
Previous Message | Stephen Frost | 2005-09-13 14:10:31 | Re: Performance considerations for very heavy INSERT traffic |