| Lists: | Postg무지개 토토SQLPostg사설 토토SQL |
|---|
| From: | "Laurent Michel" <laurent(dot)michel(at)geo12(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org>, <pgsql-cygwin(at)postgresql(dot)org> |
| Subject: | pg_restore very slow |
| Date: | 2003-07-07 15:10:15 |
| Message-ID: | 001201c34499$df15356000a8c0@montrachet |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-cygwin pgsql-general |
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
| From: | Michael Adler <adler(at)pobox(dot)com> |
|---|---|
| To: | Laurent Michel <laurent(dot)michel(at)geo12(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-cygwin(at)postgresql(dot)org |
| Subject: | Re: pg_restore very slow |
| Date: | 2003-07-10 13:30:55 |
| Message-ID: | Pine.NEB.4.53.0307100928380.17656@reva.sixgirls.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-cygwin pgsql-general |
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
| 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 |
| Lists: | Postg무지개 토토SQL Postg사설 토토SQL |
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