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$df153560$0700a8c0@montrachet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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 | Date | Subject | |
---|---|---|---|
Next Message | Xinyu Hua | 2003-07-08 00:48:58 | installation question |
Previous Message | Vladimir Kokovic | 2003-07-03 16:09:05 | I need DLL |
From | Date | Subject | |
---|---|---|---|
Next Message | Mattias Kregert | 2003-07-07 15:11:45 | Re: Datatypes and performance |
Previous Message | The Hermit Hacker | 2003-07-07 14:50:59 | Re: Gborg is down |