Thread: pg_restore very slow

pg_restore very slow

From
"Laurent Michel"
Date:
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


Re: pg_restore very slow

From
Michael Adler
Date:
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.michel@geo12.com>
> To: pgsql-general@postgresql.org, pgsql-cygwin@postgresql.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

Re: [GENERAL] pg_restore very slow

From
Jason Tishler
Date:
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