All,
For anyone who cares the "slowness solution" ended up being an"IPv6" vs
"IP4" situation.
After I changed
con <- dbConnect(drv, host = "localhost", . . .
to
con <- dbConnect(drv, host = "127.0.0.1" ....
the 'connect time went down from 15 seconds to less than 1 second.
Then I noticed ...
C:\Users\ComputerUser>ping localhost
Pinging COMPUTER [::1] with 32 bytes of data:
Reply from ::1: time=2ms
Reply from ::1: time=2ms
Reply from ::1: time=2ms
Reply from ::1: time=2ms
So i modified the 'hosts' file from
C:\Windows\System32\drivers\etc\host
from
# localhost name resolution is handled within DNS itself.
127.0.0.1 localhost
# ::1 localhost
to
# localhost name resolution is handled within DNS itself.
127.0.0.1 localhost # ( *** UN-COMMENTED ***** )
# ::1 localhost
( In order to make this change ( as Administrator ) I had to temporarily
take off the 'read only flag' on the directory
C:\Windows\System32\drivers\etc.)
Then I noticed.
C:\Users\ComputerUser>ping localhost
Pinging COMPUTER [127.0.0.1] with 32 bytes of data:
Reply from 127.0.0.1: bytes=32 time=1ms TTL=128
Reply from 127.0.0.1: bytes=32 time=1ms TTL=128
Reply from 127.0.0.1: bytes=32 time=1ms TTL=128
Reply from 127.0.0.1: bytes=32 time=1ms TTL=128
Then I tried to startup PostgreSQL again.
The startup time went down from 5 minutes to just 7 seconds!
THATS COOL!
Thanks,
Andre Mikulec
--
View this message in context:
http://postgresql.nabble.com/How-do-I-install-run-PostgreSQL-9-4-64-bit-on-Windows-7-Professional-tp5847018p5852109.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
