Re: pg_restore very slow

First, I'd recommend sticking to Debian. You are probably already aware of
the differences.

If you are stuck in WinWorld, try using the "-h `hostname`" option. It was
consistently faster for me.

On Mon, 7 Jul 2003, Laurent Michel wrote:

> Date: Mon, 7 Jul 2003 17:10:15 +0200
> From: Laurent Michel <laurent(dot)michel(at)geo12(dot)com>
> To: pgsql-general(at)postgresql(dot)org, pgsql-cygwin(at)postgresql(dot)org
> Subject: [CYGWIN] pg_restore very slow
>
> I have a pg database dump (c format) and i want to install it on
> cygwin/postgresql machines. The dump is 140 MB big.
>
> I was used to install it on windows clients with the command :
> pg_restore -d mydb -ROxv -L mylist mydump
> and it took about 1 hour or 2 maximum.
>
> Now when I issue the same command it takes more than ONE DAY for the
> dump to be fully restored.
>
> The only change I can think of is that I upgraded my Debian Linux server
> (from wich the dump comes) from pg 7.2 to pg 7.3. The
> cygwin/cygipc/postgresql is the same on clients side.
>
> I changed pg shared buffers to half of the clients RAM, and tried to
> modify pg_restore options ... nothing helped.
>
> Any idea ?
>
> Thanks in advance,
> Laurent
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

Mike Adler