Re: [GENERAL] pg_restore very slow

From: Jason Tishler <jason(at)tishler(dot)net>
To: Michael Adler <adler(at)pobox(dot)com>
Cc: Laurent Michel <laurent(dot)michel(at)geo12(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [GENERAL] pg_restore very slow
Date: 2003-07-14 12:04:50
Message-ID: 20030714120450.GA1268@tishler.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin pgsql-general

Michael,

On Thu, Jul 10, 2003 at 09:30:55AM -0400, Michael Adler wrote:
> If you are stuck in WinWorld, try using the "-h `hostname`" option.

I find "-h localhost" more convenient than the above since it does not
required editing the pg_hba.conf file.

> It was consistently faster for me.

Given that Cygwin AF_UNIX sockets are implemented by TCP/IP sockets, I
am quite surprised by the above observation.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

In response to

Browse pgsql-cygwin by date

  From Date Subject
Next Message Horak Daniel 2003-07-14 12:08:17 Re: Sorting by locale settings on Windows?
Previous Message Christoph Haller 2003-07-14 11:46:35 Re: libpq:Find Table Name

Browse pgsql-general by date

  From Date Subject
Next Message btober 2003-07-14 12:24:54 Re: select null + 0 question
Previous Message Paul Thomas 2003-07-14 10:41:15 Re: Auto Starting Postgresql Under Mandrake 9.1 ??