Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YzZ70-000739-Od for pgsql-admin@arkaria.postgresql.org; Mon, 01 Jun 2015 23:27:18 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YzZ70-0007px-60 for pgsql-admin@arkaria.postgresql.org; Mon, 01 Jun 2015 23:27:18 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YzZ6z-0007pc-12 for pgsql-admin@postgresql.org; Mon, 01 Jun 2015 23:27:17 +0000 Received: from mbob.nabble.com ([162.253.133.15]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1YzZ6r-0004g9-9s for pgsql-admin@postgresql.org; Mon, 01 Jun 2015 23:27:15 +0000 Received: from msam.nabble.com (unknown [162.253.133.85]) by mbob.nabble.com (Postfix) with ESMTP id 53AB2DFE90F for ; Mon, 1 Jun 2015 16:27:09 -0700 (PDT) Date: Mon, 1 Jun 2015 16:27:08 -0700 (MST) From: Andre_Mikulec To: pgsql-admin@postgresql.org Message-ID: <1433201228069-5852109.post@n5.nabble.com> In-Reply-To: <1431355130363-5848703.post@n5.nabble.com> References: <1430175632167-5847018.post@n5.nabble.com> <1430451396697-5847572.post@n5.nabble.com> <1431355130363-5848703.post@n5.nabble.com> Subject: Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.4 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin