From: | "Luke Lonergan" <LLonergan(at)greenplum(dot)com> |
---|---|
To: | "Jesper Krogh" <jesper(at)krogh(dot)cc>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Restore performance? |
Date: | 2006-04-10 08:04:40 |
Message-ID: | 3E37B936B592014B978C4415F90D662D01F475D5@MI8NYCMAIL06.Mi8.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Jesper,
If they both took the same amount of time, then you are almost certainly bottlenecked on gzip.
Try a faster CPU or use "gzip -fast".
- Luke
________________________________
From: pgsql-performance-owner(at)postgresql(dot)org on behalf of Jesper Krogh
Sent: Mon 4/10/2006 12:55 AM
To: pgsql-performance(at)postgresql(dot)org
Subject: [PERFORM] Restore performance?
Hi
I'm currently upgrading a Posgresql 7.3.2 database to a
8.1.<something-good>
I'd run pg_dump | gzip > sqldump.gz on the old system. That took about
30 hours and gave me an 90GB zipped file. Running
cat sqldump.gz | gunzip | psql
into the 8.1 database seems to take about the same time. Are there
any tricks I can use to speed this dump+restore process up?
The database contains quite alot of BLOB, thus the size.
Jesper
--
./Jesper Krogh, jesper(at)krogh(dot)cc, Jabber ID: jesper(at)jabbernet(dot)dk
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
From | Date | Subject | |
---|---|---|---|
Next Message | Jesper Krogh | 2006-04-10 08:22:31 | Dump restore performance 7.3 -> 8.1 |
Previous Message | Jesper Krogh | 2006-04-10 07:55:33 | Restore performance? |