Обсуждение: Slow connections on Win 7
I have been running Postgresql 9.2 under VMWare/WinXP-32bit, and it works really well.
--
John Kasarda, CFPIM, Jonah
Valid & Robust, Inc
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
I know nothing about running PostgreSQL in windows, but slowness in establishing connections on a particular host that isn'treplicable elsewhere is very often the result of something doing reverse DNS lookups on a server when accepting newconnections. Perhaps the client you are connecting from isn't set up to be resolvable via reverse dns? Maybe look in thedocs for a way to disable reverse lookups on new connections? This is pure guesswork but may give you something to investigatewhile 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 >