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

Regarding facing lot of time Consumed by Socket.Poll()

From: keshav upadhyaya <ukeshav2009(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Regarding facing lot of time Consumed by Socket.Poll()
Date: 2009-10-15 14:02:52
Message-ID: d40c44910910150702h521c42d2l49bb2b4e7c704013@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
Hi ,

In my project I use Nhibernate to connect to Postgres.
Currently it is very slow.

I have used *Yourkit* profiller to get some key informaitons.
In CPU profilling i have analyzed following  things : -
Let me explain one by one : -

1- NHibernate.Impl.SessionImpl.DoLoad(Type, Object, Object, LockMode,
Boolean)

Takes lots of time .

2- Internally it calls thse function i am listing the last stack

NpgsqlConnector.Open()
Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector)
Npgsql.NpgsqlState.ProcessBackendResponses(NpgsqlConnector)
*[Wall Time]  System.Net.Sockets.Socket.Poll(Int32, SelectMode)*

Finally in last the socket.poll takes most of the time .


I want to know the probably causes of the socket.poll() consumes allot of
time .

Please help me out to know the places why in DoLoad,DoLoadByClass and
Socket.Poll is taking lot of time .

What are the scenario in which it might be getting slow down , Which i need
to look .


-- 
Thanks,
Keshav Upadhyaya

Responses

pgsql-novice by date

Next:From: Matthew WakelingDate: 2009-10-15 14:09:11
Subject: Re: [PERFORM] Regarding facing lot of time Consumed by Socket.Poll()
Previous:From: mingsofttDate: 2009-10-15 09:38:13
Subject: visual c++ compile error when included spi.h and trigger.h

pgsql-performance by date

Next:From: Matthew WakelingDate: 2009-10-15 14:09:11
Subject: Re: [PERFORM] Regarding facing lot of time Consumed by Socket.Poll()
Previous:From: Glyn AstillDate: 2009-10-15 09:34:54
Subject: [OT] Recommended whitebox server vendors in the UK?

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