Re: Slow connections on Win 7

I know nothing about running PostgreSQL in windows, but slowness in establishing connections on a particular host that isn't replicable elsewhere is very often the result of something doing reverse DNS lookups on a server when accepting new connections. Perhaps the client you are connecting from isn't set up to be resolvable via reverse dns? Maybe look in the docs for a way to disable reverse lookups on new connections? This is pure guesswork but may give you something to investigate while you wait for a response from someone more knowledgable on your specific problem

Sent from my iPhone

On Dec 30, 2012, at 6:03 PM, John Kasarda <jbk@ValidAndRobust.com> wrote:

> I have been running Postgresql 9.2 under VMWare/WinXP-32bit, and it works really well.
> 
> I finally decided to move to my host - Win 7 Ultimate 64bit - and installed the 64bit version with same config as the 32bit.  When I tried to run it, it was extremely slow connecting to a 4 table database I use as a test when starting a server.  In pgAdminIII, any attempt to open the W7 hosted database takes 15-20 seconds.  Ditto to open a table.
> 
> I created a connection to the server in the VMWare/XP system, and performance was close to immediate.
> 
> I then removed the 64bit version, and installed the 32bit version on W7.
> 
> Same results.
> 
> So this looks like I've got something messed up on W7.
> 
> Any ideas?
> 
> TIA.
> 
> 
> -- 
> John Kasarda, CFPIM, Jonah
> Valid & Robust, Inc
>