Skip site navigation (1) Skip section navigation (2)

Re: [PERFORM] Regarding facing lot of time Consumed by Socket.Poll()

From: keshav upadhyaya <ukeshav2009(at)gmail(dot)com>
To: Matthew Wakeling <mnw21(at)cam(dot)ac(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [PERFORM] Regarding facing lot of time Consumed by Socket.Poll()
Date: 2009-10-15 14:40:00
Message-ID: d40c44910910150740w4cb805b4j8bdf0a87abf5d39c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
Thanks Matthew for your quick reply .
Let me make my self more clear.

Suppose  While doing one operation in my project,  total time taken is 41
min .

in this 41 min around 35 min is takne by this call --

NHibernate.Impl.SessionImpl.DoLoad(Type, Object, Object, LockMode, Boolean)
and DoLoadbyClass().

And i believe internally these calls used
System.Net.Sockets.Socket.Poll(Int32, SelectMode)

Which take most of the time not a bit* time .

And when i Use *MSSQL *no such kind of polling happens and it work in aound
2-3 mins .

So i believe Nhibernate config filles or some other configuration w.r.t.
Postgres  is not proper or improvement required.

Thanks,
keshav



On Thu, Oct 15, 2009 at 7:39 PM, Matthew Wakeling <mnw21(at)cam(dot)ac(dot)uk> wrote:

> On Thu, 15 Oct 2009, keshav upadhyaya wrote:
>
>> [Wall Time]  System.Net.Sockets.Socket.Poll(Int32, SelectMode)
>>
>
> RTFM. Socket.Poll *waits* for a socket. Obviously it's going to spend quite
> a bit of time.
>
> Note that it is "wall time", not "CPU time".
>
> You would be better investigating whatever is at the other end of the
> socket, which I presume is Postgres. Look at what the queries actually are,
> and try EXPLAIN ANALYSE on a few.
>
> Matthew
>
> --
> It is better to keep your mouth closed and let people think you are a fool
> than to open it and remove all doubt.                  -- Mark Twain




-- 
Thanks,
Keshav Upadhyaya

In response to

pgsql-novice by date

Next:From: Heikki LinnakangasDate: 2009-10-15 20:50:21
Subject: Re: [PERFORM] Regarding facing lot of time Consumed by Socket.Poll()
Previous:From: Matthew WakelingDate: 2009-10-15 14:09:11
Subject: Re: [PERFORM] Regarding facing lot of time Consumed by Socket.Poll()

pgsql-performance by date

Next:From: Heikki LinnakangasDate: 2009-10-15 20:50:21
Subject: Re: [PERFORM] Regarding facing lot of time Consumed by Socket.Poll()
Previous:From: Matthew WakelingDate: 2009-10-15 14:09:11
Subject: Re: [PERFORM] Regarding facing lot of time Consumed by Socket.Poll()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group